Talend Data Mapper - Add separator in AgConcat function

[param75]

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 !

[Anonymous]

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

[param75]

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?

[Anonymous]

Yes, you are right.