Dyanamic addition on target columns

bijojames · Post by **bijojames** » Thu Oct 16, 2008 8:05 am

Hi,

My sample input is as following
CUST_ID YEAR MONTH QTY
1 2008 JAN 1000
1 2008 FEB 1200
1 2008 MAR 1300
2 2007 JAN 1000
2 2007 FEB 1900

And my required target is
CUST_ID JAN_08 FEB_08 MAR_08 JAN_07 FEB_07
1 1000 1200 1300 0 0
2 0 0 0 1000 1900

Here my target is not static. For example at the end of this month i need to have one column OCT_08 in my target.
Like this it will go on

Some body please help me on this
Thanks in advance

chulett · Post by **chulett** » Thu Oct 16, 2008 8:13 am

And your 'target' is what exactly? A flat file?

bijojames · Post by **bijojames** » Thu Oct 16, 2008 8:23 am

Hi
Thats just a sample target.The target is a DB2 table

ray.wurlod · Post by **ray.wurlod** » Thu Oct 16, 2008 2:11 pm

Search DSXchange for "vertical pivot" for this is what you are attempting to achieve.