topic Talend Data Mapper - Add separator in AgConcat function in Talend Studio

Talend Data Mapper - Add separator in AgConcat function

param75 — Mon, 06 Mar 2017 08:13:15 GMT

Hello,
I have a Map (JSON structure JSON to CSV structure) where I want to loop on a field(JSON) that has multiple values in a single CSV field.

For that I thought to use the AgConcat function but it's not possible to add a separator between each concatenated value.
I also tried with a loop field output (concat Value + Constant ",") but there will always be a comma at the end.

Is there a solution I have not seen?

Thank's for your help !

Re: Talend Data Mapper - Add separator in AgConcat function

Anonymous — Mon, 06 Mar 2017 08:36:26 GMT

Hi,
Delimiters was added in 6.3 version: https://jira.talendforge.org/browse/TDM-5345
Here is a workaround:
-Do a first map with JSON as input and output structure. Map all your fields one to one but for the field you want to concatenate add a delimiter
-Do a second map JSON to CSV and use you agConcat function.
In the first map call your second map (With next map field in your map properties):

Eric

Re: Talend Data Mapper - Add separator in AgConcat function

param75 — Mon, 06 Mar 2017 10:27:52 GMT

Hi Eric,
Thank's for your reply. In your case, it will also be necessary to remove the last character in the second map because there is the separator. Yes?

Re: Talend Data Mapper - Add separator in AgConcat function

Anonymous — Mon, 06 Mar 2017 11:14:05 GMT

Yes, you are right.