mutlple columns into single column

narsi1111 · Post by **narsi1111** » Mon Jan 22, 2007 12:55 am

Hi ,

this is input structure year, jan,feb,march,april so.....on dec.

and my target structure is totalsales,periodkey

input values are year,jan,feb,march...dec

2006 200 300 400 .... 500

target should be periodkey totalsales

2006jan 200
2006feb 300
please any one can hepl me

Thanks

WoMaWil · Post by **WoMaWil** » Mon Jan 22, 2007 1:53 am

The problem is easy to solve and the question is already often asked. So simply query here and you will find the answer.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 22, 2007 4:11 am

Search for "Pivot stage". Read the Pivot stage manual. You will need an upstream Transformer stage to generate the month names in twelve additional columns.

DSguru2B · Post by **DSguru2B** » Mon Jan 22, 2007 8:02 am

As Ray advised, add the month names using transformer and then use the pivot stage. Read about its use in the manual guide.