converting XML to JSON with multiple loop elements
Hi All,
I need to convert a big XML with multiple loop elements in to JSON, please suggest me how to achieve it.
Currently I am able to convert simple XML to JSON with below design
tFileInputXML--main--tWriteJsonField--main-->tFileOutputDelimited
Please help me to understand how to achieve multiple loop elements.
Hi
There are multiple loop elements (subject and address) in the source XML file, it is able to extract the data from all loop elements with tFileInputMSXML component, but it is impossible to create multiple loop elements with tWriteJsonField component. Right now, you can only generate a json file for each loop element.
Shong