Vertical pivot or convert rows to columns

smile.achieve · Post by **smile.achieve** » Thu May 17, 2012 2:31 am

All, I am new to datstage and working on 8.1 version of it. I have a requirement where my aggregator stage outputs the data in the form of

Col1 Col2
ABC 21
xyz 52
pqr 94
opq 36
please suggest me in converting above rows in to columns like below

ABC xyz pqr opq
21 52 94 36

ray.wurlod · Post by **ray.wurlod** » Thu May 17, 2012 3:34 am

Search DSXchange for "vertical pivot"to get details of techniques. The most usual technique in parallel jobs involves Transformer and Remove Duplicates stage (given that you're on version 8.1).

sreewin7 · Post by **sreewin7** » Thu May 17, 2012 10:39 am

Adding my comments on top of below answer.

Try to do with few columns and in the server job's go to derivation tab and a column , b column give like this. may be you will get your expected output.

Thanks
sree