tfileXMLInput

Four Stars

tfileXMLInput

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?

Four Stars

Re: tfileXMLInput

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.