DSXchange

If you are saying source meaning 'Type' then yes, each row has multiple Types. Starting out with 10 types.

So it would be constant initially. As Types get added this too will need to increase going forward.

Thanks for setting me up.

DataStage version is 8.0
Windows
Linux\DB2

I tried playing with pivot transformer. Not sure if its this version but it doesn't seem to work.

I am trying to do something similar to this post... find a way in DataStage to do the following: Output from an ETL job creates a file where each row looks as: ID, date period, Type1, Totala, Totalb ID, date period, Type2, Totala, Totalb ID, date period, Type3, Totala, Totalb I like to have each row...