topic Re: Concatenate Input Columns in TMap in Talend Studio

Concatenate Input Columns in TMap

Anonymous — Mon, 02 Jul 2018 15:26:14 GMT

Hello,

I am trying to concatenate two excel input columns into one on Talend using Tmap, but the output is splitting into multiple columns because the data in columns is separated by a comma. Please see the below example:

Expected Output
Col1	Col2	OutputCol
GRETCHEN, CS	ELITE FIRE SERVICE, INC.	GRETCHEN, CS ELITE FIRE SERVICE, INC.

Generated Output
GRETCHEN, CS	ELITE FIRE SERVICE, INC.	GRETCHEN	CS ELITE FIRE SERVICE	INC

I am using row1.Col1 + row2.Col2 in Tmap expression.

Thanks

Sumithra

Re: Concatenate Input Columns in TMap

TRF — Mon, 02 Jul 2018 15:30:54 GMT

What kind of output do you expect?

Can you share you tMap + schemas?

Re: Concatenate Input Columns in TMap

Anonymous — Mon, 02 Jul 2018 15:35:20 GMT

Hi,

Thanks for Replying. My talend job looks like this.

Re: Concatenate Input Columns in TMap

TRF — Mon, 02 Jul 2018 15:38:24 GMT

For tFileOutputDelimited, change the field separator from ',' to something else like ";"

Re: Concatenate Input Columns in TMap

Anonymous — Mon, 02 Jul 2018 15:44:29 GMT

Hi TRF,

But I would need the output to be generated as a csv file which will be separated by comma. Is there any other way we can approach?

Sumithra

Re: Concatenate Input Columns in TMap

TRF — Mon, 02 Jul 2018 15:47:28 GMT

If you want field separator as comma and you also have commas into the field value, then you have to enclose fields between "" or any character you want.

Re: Concatenate Input Columns in TMap

fdenis — Mon, 02 Jul 2018 15:47:34 GMT

in your tfileOutputDelimited in Advenced setting add CSV option

Re: Concatenate Input Columns in TMap

manodwhb — Tue, 03 Jul 2018 06:47:35 GMT

@skrc0213,please find the below are you looking for?

JobOutputtmaptFileOutputDelimited settings

Re: Concatenate Input Columns in TMap

Anonymous — Tue, 03 Jul 2018 10:49:29 GMT

Thanks aton fdenis.. It worked....

Re: Concatenate Input Columns in TMap

Anonymous — Tue, 03 Jul 2018 14:08:28 GMT

Hello Fednis,

So what should be the settings after checking csv option. It has escape characters and text enclosure. I just need a csv files with comma separated values.

Thanks

Sumithra

Re: Concatenate Input Columns in TMap

fdenis — Tue, 03 Jul 2018 14:38:19 GMT

it's the limitation of csv. if you did not want csv option the only way is to allow separator only on the last field.
that's why you can choose your separator!
that's why there is others files format!