Append/Merge input fields into single field
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...
Forum Discussion
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
