DSXchange

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

Refer Pivot stage

DS User

Thanks, what should be the derication in output column tab?
addrcolumn where address no = 1?

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.

thanks now I am trying to vertical pivot.

My question is when I have addr1 addr2 and addr3 in my target. and source is having addrtxt and addrno. how to configure stage vertical pivot to populate field addr1 in target when addrno is 1 in source?

That is totally the opposite to the requirement you descrived originally. Please confirm what your requirement actually is.

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?