Concatenate Input Columns in TMap

[Anonymous]

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

[fdenis]

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!