tfileXMLInput

sonalijagtap — Wed, 08 Aug 2018 12:34:39 GMT

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?

Re: tfileXMLInput

Anonymous — Wed, 08 Aug 2018 16:12:24 GMT

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.