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 to look like this:
ID, date period, Type1, Totala, Totalb, Type2, Totala, Totalb, Type3....
I am extremely new with DataStage so reaching out to the Gurus here. Help is really really appreciated.
Concatenate the rows
Moderators: chulett, rschirm, roy
Welcome aboard... a couple of things.
First, I've put you into your own post and linked back to the 'similar' thing you are trying to do. Secondly, this meant I had to guess at some things, can you clarify for us:
1) Your DataStage version
2) Your server Operating System
Thanks.
I'd also be curious what you've tried, any kind of pivoting that the post you found mentioned?
First, I've put you into your own post and linked back to the 'similar' thing you are trying to do. Secondly, this meant I had to guess at some things, can you clarify for us:
1) Your DataStage version
2) Your server Operating System
Thanks.
I'd also be curious what you've tried, any kind of pivoting that the post you found mentioned?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3
- Joined: Thu Dec 18, 2014 7:37 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3
- Joined: Thu Dec 18, 2014 7:37 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
It can be achieved in newer versions with vertical pivot or looping but there functionality is not available in 8.0. Do a search on vertical pivot and look for some answers for pre 8.5 version. Should also be achievable with stage variables but a little tricky to identify the last record.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.