<<<XML Parse Tool with nested XML structure>>>

[tamluenwai]

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?