I want to perform a XML parsing, and I would like to know each element they are under which parent element. The XML file contains 3 different childs "form", "submit", "data" under the parent element"submission".
Expected output
Name | Value | Parent Name |
formid | ABC0123 | form |
captchaMethod | AA_Hello | form |
... | ... | ... |
trnid | AA012363QPS2RTVS | submit |
... | ... | ... |
clientWhatsapp | 21234567 | data |
But I got some limitation of my workflow:
Firstly,the file format must be "Extensible Markup Language (*.xml)", instead of "Comma Separated Value (*.csv) in input tool configuration. Here's the screenshot of input tool configuration and the output result of after executing the input tool.
Secondly, I have dragged a "XML Parse" tool after the "Input tool", and the configuration and output as follow:
Based on this 2 limitation, i would like to know how to perform the XML parsing to obtain the desire output result as above shown in the table?