from the snippet of your XML, I would suggest using the XMLExtract component to generate the XSD schema and take advantage of its visual mapping feature. Moreover, I would recommend using the ‘Populate parent record’ functionality as the fundamental concept of your data extraction as it helps flatten the output data structure, thus reducing the number of output ports. More information about this concept can be found in our documentation (namely in the ‘XMLExtract Mapping Editor and XSD Schema’ part).
Attached is an example solution based on the provided input data. I have demonstrated 2 approaches one of which extracts the data in a flat structure while the other one sends the data to 2 different ports. If you have any additional questions, feel free to get back to us.
- (8.88 KiB) Downloaded 76 times