Can we output into XML format?

Question

I've tried to search but the posts all reference a macro that is no longer available so I thought I would ask for more updated information.  I have a process that analyzes and transforms elevated delegate access data to be uploaded to the Dayforce payroll system.  However, the data has to be in XML for my IT associates to perform the upload.  The IT associate currently has to take the Excel file I've output from my Alteryx workflow and copy and paste it into another XML template.

Is there any tool that can help me remove this inefficiency of having to copy from Excel and paste into XML?  Thank you.

c-lopez · Answer

Hi @ELPC,

As pointed out before you will not be able to output to xml directly. I would encourage you to try out the Python tool and use Pandas to format your output as you need it or use other python functions here is an example:
https://stackoverflow.com/questions/41059264/simple-csv-to-xml-conversion-python

Regards

apathetichell · Answer

there is no out of the box way to create an .xml file in Alteryx. You would need to transpose your data and create your key/value pairs with the proper header structure. You would then output your file to utf-8 encoded /n delimited .csv - and send in a filename to change filename/change entire path to {yourfile}.xml in your output data.