Solved
How to split a value into multiple fields
Hello,
Say I have a .csv with the following row:
value1_value2_value3_value4_value5
How can I split the string by “_” so each value can be mapped to its own field? I basically need to do stuff with each record, but through the Mapper I can’t seem to figure out how to accomplish this.
Mapping from: “value1_value2_value3_value4_value5”
To:
“value1”
“value2”
“value3”
“value4”
“value5”
Thank you in advance.
Best,
Izzy Babcock
Hello @izzy.babcock,
You can use .split() method in a mapper like this →
$row.split("_"), this will create an array then you can simply map that value to the target path and after that use a JSON Splitter to split on the target path containing the array fields.
