splitting sub records!!!

[allavivek]

Hi All,

I was trying to split subrecords as below..

Code: Select all

result    first         second
1        (1,aaa,bbb,)   (3,aaa,bbb)

I was using promote subrecord stage...i can only give one parent column in this stage(first) but iam having two parent columns(first and second) ....Another question is how should be the output columns given???

[DSShishya]

Its kind of difficult to understand your requirement. Can you please elaborate more or put the records and result in a orderly manner?.

[allavivek]

Its kind of difficult to understand your requirement. Can you please elaborate more or put the records and result in a orderly manner?.

i/p data is below...actually its an output data from compare stage...

Code: Select all

result     first     last
1      (1,aaa,bbb)  (3,aaa,bbb)
1      (3,fff,ggg)    (5,ffff,gggg)

o/p should be

Code: Select all

result   col1 col2 col3 col4 col5 col6
1          1      aaa bbb   3   aaa  bbb
1         3      fff     ggg   5   ffff   ggg

[DSShishya]

Looks very simple.

Use the String function "Index" on the "first" and "last" columns of the input in order to get the desired output in col2,col3...

Refer the developer's guide for syntax on the "Index" function.

[DSShishya]

I'm sorry, that would be the "Field" function, not the Index.

[ray.wurlod]

Two subrecords ---> two Promote/Split Subrecord stages.