topic Extracting xml fields in Talend Studio

Extracting xml fields

AbiJeev — Fri, 15 Nov 2024 22:34:16 GMT

Hi,

I have a requirement , from xml I need to fetch data and load to table.

My table has column name "Insert_Rows". For that I need to fetch data from below xml,

<NAME>INSERT_ROWS</NAME>

<NAME>UPDATE_ROWS</NAME>

</PARAMETERS>

I need to fetch only insert rows count 1 not update rows count 5. Based on name I have to fetch . Please let me know which component to use and how. THANK YOU

Re: Extracting xml fields

AbiJeev — Thu, 08 Sep 2022 22:56:12 GMT

Hi Found a solution with tXMLMap by giving parameter as loop element and sending to tAggregaterow , but is there any other option available

Re: Extracting xml fields

Anonymous — Fri, 09 Sep 2022 05:04:09 GMT

To extract data from a XML string, we usually use tExtractXMLFields.

Regards

Shong