Forum Discussion

smeitei's avatar
smeitei
New Contributor II
5 years ago
Solved

Concatenate field values from multiple rows to single row/documents

I am looking for a solution to concat all the field values from multiple row into single separated by delimited symbol ‘!’. Input data: [ {“Record”: “1”}, {“Record”: “2”}, {“Record”: “5”}, ...
  • j_angelevski's avatar
    j_angelevski
    5 years ago

    Hi @smeitei ,
    First you need to group all input documents into a single array. For that you can use the Group by N snap with the setting “Group size” seto to 0. Then use a mapper with the following expression: jsonPath($, "Records[*]").map(val => val.get("Record")).join("!")


    Output:

    You can also use the Aggregate snap, but this will use the default delimeter.

j_angelevski's avatar
j_angelevski
Contributor III
5 years ago
Copy Link

Hi @smeitei ,
First you need to group all input documents into a single array. For that you can use the Group by N snap with the setting “Group size” seto to 0. Then use a mapper with the following expression: jsonPath($, "Records[*]").map(val => val.get("Record")).join("!")


Output:

You can also use the Aggregate snap, but this will use the default delimeter.