Converting rows to columns

chitravallivenkat · Post by **chitravallivenkat** » Thu Jul 31, 2008 9:26 pm

Can any one suggest me how to convert rows into column.
i have addresses field in the source with an seq_num as key column in that table. the following i have illustrate how the input is and my output should look like

INPUT
seq_num address1
1 no 291
2 I st floor
3. Nandini Apartment
4. shivajinagar
5. Bangalore

OUTPUT should be
Orgl_add1 Orgl_add2 Orgl_add3 Orgl_add4 Orgl_add5

no 291 I st floor Nandini Apartment shivajinagar Bangalore

So plz help me out in resolving the above query...

ray.wurlod · Post by **ray.wurlod** » Thu Jul 31, 2008 10:05 pm

What you are asking about is called a "vertical pivot". Searching DSXchange will yield at least three different ways to accomplish vertical pivoting in DataStage server jobs.

chitravallivenkat · Post by **chitravallivenkat** » Fri Aug 01, 2008 1:29 am

First of all let me thanks u for ur rpy...
but how we implement this in vertical pivoting... I am new to datastage so plz advice me

chulett · Post by **chulett** » Fri Aug 01, 2008 1:34 am

As noted, search the forums for the phrase "vertical pivot". The how to implement part has been posted many times out there.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 01, 2008 3:22 am

U is one of our posters (and a reasonably common Burmese name), Ur was a city in ancient Babylon, and rpy presumably is an abbrevation for revolutions per year. Plz might be a town in the Balkans.

Please use a professional standard of English when posting on DSXchange; it makes it easier for everyone.