Split XML into different row

[tamluenwai]

Problems

I got an XML file and I have to set the file format as ".*XML" instead of "*.CSV", and I got the output as below attached screenshot.

I would like to know how to split the data into different row?

Expected Result

<submission>

<form>

<formId>AA0121</formId>

<captchaMethod>DX_RISKLEVEL</captchaMethod>

...

</form>

<submit>

<trnId>AA012163QPS1LN51</trnId>

...

</submit>

<data>

<clientContactAddress>CA</clientContactAddress>

...

</data>

</submission>

[Manoj_k]

Hi @tamluenwai is this that you were looking.

  

[flying008]

Hi, @tamluenwai 

FYI.

[tamluenwai]

Hi, @flying008 

Since I got a new XML file, it contains 3 different child element (form, submit, data) under the parent element (submission). Compare with this XML file, the last XML file it just contains 2 child elements (form and submit). 

Therefore, it seems like I cannot use the same method to split the data.

The file that I have uploaded above is the latest XML file, and I’m also wondering is there any methods that allows me to split the XML into different row, without changing the file format to ‘flat’ to archive the same result? 

[tamluenwai]

@Manoj_k 

I’ve followed your configuration setting l, but it dont have any changes :(

[flying008 · Accepted solution]

Hi,@tamluenwai 

Try this way.

[flying008]

Hi, @tamluenwai 

Depending on the structure of your existing file, it is not possible to import it in XML format to just get the wrap result, you have to wrap the line after the input to achieve the output you want. ( .csv and .xml formats all both can be input like @Manoj_k , but the options are different, and you need to wrap the line later.)

[tamluenwai]

@flying008 

Thanks for your help!! It works perfectly. I have been stuck to this problems for a few days already.