Getting input as
Name Addresslineno Address
ABC 1 xyz
ABC 2 bhc
ABC 3 320
DFG 1 frfd
DFG 2 fgfg
Output required is
Name Address1 address2 address3
ABC xyz bhc 320
DFG frfd fgfg
please drop a note to inplemet this logic, if in sql also will do
design question
Moderators: chulett, rschirm, roy
Re: design question
Refer Pivot stage
DS User
DS User
Re: design question
Thanks, what should be the derication in output column tab?
addrcolumn where address no = 1?
addrcolumn where address no = 1?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What you are seeking to achieve is called a "vertical pivot". Search DSXchange for examples.
You need version 8.5 to accomplish a vertical pivot using a PXPivot stage.
You need version 8.5 to accomplish a vertical pivot using a PXPivot 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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Srry in case of confusion.
In example mentioned earlier
Name Addresslineno Address
ABC 1 xyz
ABC 2 bhc
ABC 3 320
DFG 1 frfd
DFG 2 fgfg
Output required is
Name Address1 address2 address3
ABC xyz bhc 320
DFG frfd fgfg
So in input i have addrs and addresslineno so in vertical pivot how so map these input columns to address1 , address2 and address3 columns?
In example mentioned earlier
Name Addresslineno Address
ABC 1 xyz
ABC 2 bhc
ABC 3 320
DFG 1 frfd
DFG 2 fgfg
Output required is
Name Address1 address2 address3
ABC xyz bhc 320
DFG frfd fgfg
So in input i have addrs and addresslineno so in vertical pivot how so map these input columns to address1 , address2 and address3 columns?