Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Anonymous
Not applicable

OK, to start I should say that this can be painful. It is not pleasant to work with XML like this with any product. However Talend does have the Talend Data Mapper in the Enterprise Edition. If you have that, use it. It isn't like ANY of the other Talend components, can be a real pain to find documentation, but once you get used to it, it really does help. If you are using the Open Source product, you are left with using multiple tExtractXMLField components. I gave an explanation as to how to do this here (https://community.talend.com/t5/Design-and-Development/Complex-XML-with-multiple-loops-into-one-outp...). At some point I will put together a mini tutorial, but you will learn a lot if you try this out yourself from the description I have given. As I said, it is not pretty, but once you get to grips with it, it isn't so hard.

View solution in original post