DSXchange

If you know the Maximum occurances of ~ then you can use Field of Function...define as many stage variables as occurances of ~ Field(DSlink.Value,"~",1) Field(DSlink.Value,"~",2) Field(DSlink.Value,"~",1) ----- ------ So on Then Concatinate all these stage variables wit...

... or use a Remove Duplicates stage to take the final member of each group (which you would have found had you really done "enough" searching). ... Thanks Ray.....But seems like u didn't get the Problem....i know how to capture the Last row with the values..But my Problem was to flush th...

Hi, I am trying to achive a vertical Pivot in a transformer. My Input looks like this Col1 is the Key column and Col2 is the value column Col1 Col2 A 1 A 2 A 3 B 4 B 5 B 6 I am trying to get the Output as where '-' is Null Col1 Col2 Col3 Col4 A 1 - - A 1 2 - A 1 2 3 B 4 - - B 4 5 - B 4 5 6 I have a ...