split records
Posted: Mon Jul 21, 2008 11:10 am
Hi,
I have a requirement to split the sub records. Input contains following fields.
Col1 ->a1|a2|a3
Col2 ->abc
Col3->10
My output should be:
col1 col2 col3
a1 abc 10
a2 abc 10
a3 abc 10
I achieved this by using a transformer. But my col1 may contain upto 50 delimited values,which resluts in 50 links to transformer, so I was asked to go for an alternative approach. Can anyone suggest me an alternative approach to achieve this.
Thanks
I have a requirement to split the sub records. Input contains following fields.
Col1 ->a1|a2|a3
Col2 ->abc
Col3->10
My output should be:
col1 col2 col3
a1 abc 10
a2 abc 10
a3 abc 10
I achieved this by using a transformer. But my col1 may contain upto 50 delimited values,which resluts in 50 links to transformer, so I was asked to go for an alternative approach. Can anyone suggest me an alternative approach to achieve this.
Thanks