tfileXMLInput

[sonalijagtap]

Hi Team,

I am reading the complex XML file. I am getting one field in multiple node. How to read it.

In one node, StoreID is coming at  Event/Node/StoreID

in another node its like Event/Node/Tender/StoreId

like wise I am getting StoreId at different level.

How to write the XPath query to read StoreID?

[Anonymous]

Hello,

You can do it in two steps with tExtractXMLField component :

- 1st component : loop = Event/Node/Tender/StoreId

- 2nd component : loop = Event/Node/StoreID

Then you can merge the results tables with tUnite.

Regards,

Aurélien.