Please have a look at the XML file structure below. We are looking for a way to parse this document without the need to specify the exact structure of the document. Is there some kind of way within the standard components from Talend where we can parse this document? Basically what I would like to do is the following: # Start parsing the document. # Loop through the <products> # For each element inside a product, find the next (new) element and save corresponding value and parent ID, etcetera. EXAMPLE XML STRUCTURE
In other words: we don't now what elements we can expect in the XML structure. The component just should create a table containing (sub)elements and their corresponding key. I think a lot of people want a component like this and and my opinion I think it is very strange that an ETL tool like Talend does not have this.
What you need is something like a normalizer for XML which returns all tags with values and the path to the tag. Which such kind of component (it should use a SAX parser without memorizing the DOM) you should be able to retrieve everything - even unknown structures. I will take a look if I can create such component.
We have already created some java which does the parsing. The problem is that we want to wrap the java code into a Talend component. It would be great if the component has an input parameter (the xml file to be parsed) and as an output a row containing key/value. How do we create such a component?
