Convert XML content to PDF

[ssripat3]

Hello Alteryx community,

I have a question regarding the possibility of converting the XML code to a PDF file. For example, assume we have the XML from this link.

I would like to take the XML in its Raw format and possibly use Render to create a .pdf file with the same content without any changes. 

Is this something that is possible with Alteryx?

Thank you

[danilang]

Hi @ssripat3 

Use an Input tool to read the xml as a .csv file with \0(no delimiter) as a delimiter.  Pass this to a Table tool and then a Render tool formatted to output a pdf file.  

Dan

[ssripat3]

Hello danilang,

Thank you for the quick reply. I tried the way you recommended and it did not work exactly as intended. The end output was out of order and did not replicate the exact format the XML was in.

Thank you for the help.

I am sharing the PDF file that was generated so you have an idea and also the workflow so you have an idea of the settings I used.

[ssripat3]

Hello Dan, instead of using the Table tool. I chose to use "Report Text" which kind of worked better for me. 

I was able to generate the PDF and the format also stayed intact.

[danilang · Accepted solution]

@ssripat3 

Use \0 as opposed to \n as the delimiter in the input tool(sorry about the original error).  Uncheck Field 1 in the Group By section of the table tool.  

There's also an issue with the table tool removing leading spaces, use a formula tool and replace all spaces with non-breaking spaces ASCII(160)

Output looks like this now

Dan

[ssripat3]

Thank you for the updated solution and the workflow @danilang . It works perfectly.