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”},
{“Record”: “4”},
{“Record”: “6”}
]

Expected Output:

[
{“Records”: “1!2!5!4!6”}
]

  • koryknick's avatar
    koryknick
    4 years ago

    Remapping all field names can be done using the Object.mapKeys() method. For example:

    Hope this helps!

  • darshthakkar's avatar
    darshthakkar
    3 years ago

    Hi mkadange,

    Welcome to SnapLogic and community. Yes, you can simply drag and drop the columns on the target path as you did for input/expression. Please try that out once for a small set and selecting All and dropping it on the target will do the needful.

    Also, let's assume, out of 400, you need to select 40 which are not in the order, drag and drop will automatically map it for you.

    Please keep us posted with your results.

    Regards,

    Darsh

3 Replies

  • j_angelevski's avatar
    j_angelevski
    Contributor III
    5 years ago
    Copy LinkReport

    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.