Transposing in Datastage

dsoupaty · Post by **dsoupaty** » Tue Jul 29, 2014 2:10 pm

Hello

I have a requirement where i have the data as below

Col col2 col3 col4 col5
12345 ABC INR INR 1000
12346 ABC USD USD 1000

I need the output as below

Col col2 col3 col4 col5
12345 ABC INR USD 1000
12346 ABC USD INR 1000

appreciate your help

Thanks

chulett · Post by **chulett** » Tue Jul 29, 2014 2:19 pm

Spell out your requirements in words rather than simply post before and after pictures. This not only helps us but could very well help you as well.

dsoupaty · Post by **dsoupaty** » Tue Jul 29, 2014 2:39 pm

Sorry Chulett

I have 2 records in the group and group is determined by col5 ( ASSET_ID) and col2 (SEC_CD) combination.

Col3 and col4 are ASST_CRRNCY and LOCAL_CRRNCY. in the group of records ( 2 records) the ASST and LOCAL Crrncy will be the same in each row from source.

The output that i need to generate for that group must have col4 ( LOCAL_CRRNCY) flipped.( i.e USD instead of INR for LOCAL_CRRNCY and INR instead of USD for LOCAL_CRRNCY)

I hope i made my self clear

Thanks