How concatenate 2 columns that contains multiple data

Anonymous — Sat, 16 Nov 2024 03:05:35 GMT

I work with Talend 6.3. I want to concatenate 2 colomns in tmap. But in specifics rows, there are multiple data and i want match them the first with the first of the row in the other column.

Initally it's an exemple with name but i use TNormalize/TDenormalize to regroup all organisations for 1 Users. But in the cel of concat i want to have -> KEVIN-MONTA,ZOE-REY,-ALAN-ZOM ...

I don't know if i explained that correctly but tell me if someone need more informations.

I try it Name + "-" + Surname but i have this :

Maybe it's cause of my TNormalize/TDenormalize :

Initally it's an exemple

Thanks in advance

Re: How concatenate 2 columns that contains multiple data

cmendels — Fri, 06 Mar 2020 18:49:00 GMT

I'm not sure if this would fit your needs, but I created this job based on your sample data. I assumed Excel input because you said "cell". Normalize the first name and last name separately, then add a sequence number. Join based on sequence number, concatenate, then denormalize.

topic How concatenate 2 columns that contains multiple data in Talend Studio

How concatenate 2 columns that contains multiple data

Re: How concatenate 2 columns that contains multiple data