Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Can we output into XML format?

ELPC
8 - Asteroid

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.  

2 REPLIES 2
apathetichell
20 - Arcturus

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.

c-lopez
Alteryx
Alteryx

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

Labels
Top Solution Authors