XML not outputting correctly - need to take new line following root, child & subchild

[HenpetsGordres1]

Hello,

I have a workflow which is supposed to output to XML format, but when opened in Notepad, appears like this:

I need to Input this XML in CSV format in Alteryx, which looks this:

I need to format it correctly so that it appears like this in Notepad:

which in turn appears like this as a CSV in Alteryx:

So essentially I think I need to take a new line (new record) every time following every subchild e.g. </calories> as well as the root & child values e.g. <breakfast> & <food>.

Is this possible?

Many thanks

[DavidP]

Something like this?

[HenpetsGordres1]

Hi David,

Many thanks for your efforts. This is almost what I need, it may make it a lot harder but I would like the subchild with values to remain on the same line. So something like this:

I'm not sure if this is possible though?

Thanks,
Stephen

[DavidP]

Try this version

[DavidP · Accepted solution]

My previous tweak didn't correctly put <breakfast_menu> on it's own line. Here's the same idea but implemented slightly differently to fix that issue