converting a single row to multiple rows

nishantrk · Post by **nishantrk** » Thu Jun 02, 2011 12:14 pm

I have the data coming in as below
col1 col2 col3 col4
Jay x x
kay x x

output :Insert into DB2 table using ODBC

jay col2
jay col4
kay col2
kay col3

Since we have only 8.1 version..I was thinking for having a transformer stage with 3 outputs each having a constrain on cols2,col3 col4 respectively.

Since am brand new to data stage , curious to know if this could be done by other methods and their merits..

vinothkumar · Post by **vinothkumar** » Thu Jun 02, 2011 1:27 pm

Search for "pivoting" in this forum which helps you more on this.

chulett · Post by **chulett** » Thu Jun 02, 2011 1:51 pm

A "horizontal pivot" specifically... columns to rows.

Bicchu · Post by **Bicchu** » Wed Jun 08, 2011 3:51 am

A pivot stage can able to solve the problem. In the derivation section of the output tab in the pivot stage, give the column names that you want to convert from horizantal to vertical form.

satisht · Post by **satisht** » Fri Jun 17, 2011 1:38 pm

Yeah Pivot can help

ray.wurlod · Post by **ray.wurlod** » Fri Jun 17, 2011 4:04 pm

Use a Pivot stage (or a PXPivot stage).