Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
SagarMelam
- Participant
- Posts: 26
- Joined: Mon Apr 21, 2008 4:03 am
- Location: Amalapuram
Post
by SagarMelam »
Hi ,
I have a scenario below
SID QuestionNo AnswerInfo
101 1 A1
101 1 A2
101 1 A3
101 1 A4
101 2 A2
101 3 A5
My o/p should be
SID QuestionNo AnswerInfo
101 1 A1 ,A2 ,A3 ,A4
101 2 A2
101 3 A5
Please let me know
Sagar
-
sharmabhavesh
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 38
- Joined: Tue Jun 19, 2012 11:03 pm
- Location: India
Post
by sharmabhavesh »
Use a pivot stage and keep the 1st two columns as keys. NULL will be populated for columns which do not have a value.
-
SagarMelam
- Participant
- Posts: 26
- Joined: Mon Apr 21, 2008 4:03 am
- Location: Amalapuram
Post
by SagarMelam »
Vertical pivot should be used right ?
Sagar
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Yes. Vertical pivot a.k.a. Rows to Columns.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
The answer to your next question is "Remove Duplicates stage preserving Last row in each group and Column Export stage."
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
-craig
"You can never have too many knives" -- Logan Nine Fingers