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?
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema