XML merge node attribute with child attribute

[andreasignori]

Hi

I'm currently developing a job to read and get the data from this xml https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist-90d.xml .

I need to get this information like:

<DATA> | <CURRENCY> | <RATE>.

Using xPath i manage to do this:

And the result is :

Now i need to have it for every single currency and not only for USD, how can i get every single value for every single currency, and still get the result as <DATA> | <CURRENCY> | <RATE>?

Thanks for you patient (I'm new in talend 😄 I like it)

[Anonymous · Accepted solution]

Hi

Read the file as a document and extract value from the document on tXMLMap, see

on tXMLMap, import the XML tree structure from file.

 

Hope it helps you!

Regards

Shong

[andreasignori]

Sir, i owe you a coffe, probably a beer, and maybe one pizza too. Thank you!

[andreasignori]

may i ask you another question? Is possible to automatically read the tree schema? (I had to do it manually)

[Anonymous]

Impossible, you have to import the tree schema from file/repository or define it at design time.