Extracting xml fields

[AbiJeev]

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,

<PARAMETERS>

<PARAMETER>

​ <NAME>INSERT_ROWS</NAME>

<VALUE>1</VALUE>

<PARAMETER/>

<PARAMETER>

​ <NAME>UPDATE_ROWS</NAME>

<VALUE>5</VALUE>

<PARAMETER/>

</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

[AbiJeev]

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

[Anonymous · Accepted solution]

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

Regards

Shong