How to split a comma separated string retrieved from a tXMLMap

[riptidas]

I have a XML which I parsed using tXMLMap and now i have multiple fields with comma separated string.

I need to convert them into arrays with separator as comma.

However, I also have a key parameter in tXMLMap output that is required for upsert into existing collection.

[MattE]

Could you configure it so the output of your txmlmap is the key value then a string field where you concatenate all the values into a comma separated string e.g.

row1.value1 + ", "+ row1.value2 + ", "+ row1.value3

etc?