Split XML into different row

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

Hi,@tamluenwai

Try this way.

录制_2024_03_06_09_58_13_934.gif

录制_2024_03_06_10_00_36_96.gif

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335