Inserting Fieldname with Pivot Stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
endyl13
Premium Member
Premium Member
Posts: 44
Joined: Tue Jun 25, 2002 12:47 am
Location: Qatar
Contact:

Inserting Fieldname with Pivot Stage

Post by endyl13 »

I have a seq file data source which has 103 columns. Some of the columns (99 cols) are data with the same type (Revenue) but named differently (Rev_Jan_89, Rev_Feb_89, etc)
I am using Pivot stage to make all 99 cols become 99 rows of Revenue data. I managed to do it for the Revenue, but I also need to put the fieldname (Rev_Jan_89, etc...) into another column in the target, so that each Revenue data will have one Revenue_Period.

How can I insert the fieldname with Pivot or any other stages?

Really need help on this one.

Thanks....

Regards

ND
Post Reply