concatenate

IBMDS · Post by **IBMDS** » Fri Feb 22, 2008 1:07 pm

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

chulett · Post by **chulett** » Fri Feb 22, 2008 1:10 pm

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

IBMDS · Post by **IBMDS** » Fri Feb 22, 2008 1:25 pm

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

kcbland · Post by **kcbland** » Fri Feb 22, 2008 1:25 pm

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.

IBMDS · Post by **IBMDS** » Fri Feb 22, 2008 1:52 pm

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

Thanks in Advance
DS

Teej · Post by **Teej** » Fri Feb 22, 2008 3:08 pm

--> 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.

kab123 · Post by **kab123** » Fri Feb 22, 2008 3:48 pm

I believe a pivot stage can do this.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 22, 2008 5:34 pm

Care to explain how?