Append/Merge input fields into single field

[Surendar]

I have list of fields with name like,

• amount_1
• amount_2
• amount_3
• amount_4
• …

I need to map all the amount fields value into amount column in target.

Example:

Note: the fields is dynamic we can get “n” number of fields.

Looking forward any inputs/suggestions

[cjhoward18]

Hi Surendar,

Assuming this is just a CSV, I plugged in your example data into a CSV generator, followed by a ‘group by N’ snap, which will group csv docs(up to 10,000) into a single doc assigned to any key you want, I chose ‘group’ for my key.
Then that will flow into a mapper with the expression as : “$.group.map(val => parseFloat(val.value))” with target field as ‘amount’ and you will be left with a list of all your values.
If you don’t care about the value being a string, you can leave out the parseFloat() call in the expression.

Hope this achieves your goal