topic How to split a comma separated string retrieved from a tXMLMap in Talend Studio

How to split a comma separated string retrieved from a tXMLMap

riptidas — Sat, 16 Nov 2024 02:11:03 GMT

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.

Re: How to split a comma separated string retrieved from a tXMLMap

MattE — Wed, 10 Jun 2020 14:05:48 GMT

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?