Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What kind of output do you expect?
Can you share you tMap + schemas?
Hi,
Thanks for Replying. My talend job looks like this.
For tFileOutputDelimited, change the field separator from ',' to something else like ";"
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
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.
Thanks aton fdenis.. It worked....
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