DSXchange

Hi all, Here's the requirement that i'm facing: I have an input file with two columns : For example, the first column contains : "a" The second column contains : "1col1|2col2|3col3". Do you know how i can do in the "derivation" of my pivot to have in my output file : &...

Another option. User transformer to Split the second column into three. In.Column[1,INDEX(In.Column,'|',1)-1] for the first link In.Column[INDEX(In.Column,'|',2),(INDEX(In.Column,'|',2)-INDEX(In.Column,'|',1)-)] for the second link In.Column[INDEX(In.Column,'|',3),(Len(In.Column)-INDEX(In.Column,'|...

Hi all, Here's the requirement that i'm facing: I have an input file with two columns : For example, the first column contains : "a" The second column contains : "1col1|2col2|3col3". Do you know how i can do in the "derivation" of my pivot to have in my output file : &q...