DSXchange

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

Spell your requirements out in words. That would help both us and yourself as well.

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 TCTSV03RAPJPG
ABCD 3 TCTSV03RAPJPG

You require two passes thru the data. The first pass is to build the concatenated result, then second is to put that result on all constituent rows.

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

Thanks in Advance
DS

--> Transformer --> Remove Duplicate --> Lookup. One link feed the Remove duplicate, and another link is the primary to Lookup. First link feed the appending of values, and you get the last value for the remove duplicate. Feed it to Lookup as reference link.

That's just one solution of many that can be done here.

I believe a pivot stage can do this.

Care to explain how?