PIVOT Stage

aluthra48 · Post by **aluthra48** » Fri Jul 31, 2009 1:18 pm

Can someone help me in configuring the Pivot Stage? The input data coming in is

A, B, C, D

and I need the output to be:

A, B, C1, C2, D1, D2

Example:
Input:

12345 aaaa c1 d1
12345 aaaa c2 d2

Output:
12345 aaaa c1 c2 d1 d2

Thank you

nagarjuna · Post by **nagarjuna** » Fri Jul 31, 2009 1:35 pm

Is it a pivot or join ??

aluthra48 · Post by **aluthra48** » Fri Jul 31, 2009 1:46 pm

PIVOT

Thanks

roy · Post by **roy** » Fri Jul 31, 2009 2:02 pm

I think the obvious solution is using stage variables in a transformer, but, in case the number of reoccurances is varying you might need to build a routine that concatenates the fields

aluthra48 · Post by **aluthra48** » Fri Jul 31, 2009 3:54 pm

I can use the 1st occurence for C1 and the last for C2. Ditto for D.
Can you explain how to use the stage variables in a transformer to accomplish this?
Thanks

aluthra48 · Post by **aluthra48** » Fri Aug 21, 2009 3:43 pm

Used T-SQL to create the pivot