Vertical pivot or convert rows to columns
Posted: 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
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