I have a positional file that I need to convert to a number of XML files. Unfortunately the XML structure has two, separate, sequences which tAdvancedFileOutputXML cannot support (I can only specify a single looping element).
Below is a mocked structure of the current job:
1. What is the preferred approach ?
2. If I continue with this solution how do I make sure that the 3 inputs on the right wait for the tAdvancedFileOutXML components to finish and how do I trigger them ? I tried a linked set of tWaitForFile but that didn't seem to work as expected.
Solved! Go to Solution.
You might want to use a similar solution to the one I have described here but for JSON (https://community.talend.com/t5/Design-and-Development/How-to-Denormalize-a-JSON-source/m-p/26161#U2...). You would use tExtractXMLField components rather than the JSON equivalent (and will need a bit of XPath knowledge).
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