DSXchange

Could you tell me how to build the concatenated result. My source is a sequential file.

Thanks in Advance
DS

The source file contains the data in different lines for one group. i need to concatenate the col3 for particular group and populate for all the lines in that group. Col1 Col2 col3 ABCD 1 TCTSV03 ABCD 2 RAP ABCD 3 JPG I would like get the output Col1 Col2 col3 ABCD 1 TCTSV03RAPJPG ABCD 2 TCTSV03RAPJ...

Hello,

I getting the source like this

ABCD 1 TCTSV03
ABCD 2 RAP
ABCD 3 JPG

I would like get the output

ABCD 1 TCTSV03RAPJPG
ABCD 2 TCTSV03RAPJPG
ABCD 3 TCTSV03RAPJPG

Thanks in Advance
DS

I have a scenario like this In source i have multiple values in lookup table i have distinct records Source table column1 xyz all a xyz-all xyz - all rxz rxzab - 1 rxzab - all In lookup table Lcolumn1 Lcolumn2 Lcolumn3 xyz 2 1 rxz 3 2 i need to get the ouput like this Column1 Lcolumn2 Lcolumn3 xyz a...