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
Inserting Fieldname with Pivot Stage
Moderators: chulett, rschirm, roy