Output to an Excel workbook with XML mappings instead of .csv file

[EricMartinson]

Hello!

The current output for my workflow is several .csv files but then the user has to copy the contents of each file and paste it into an Excel workbook that has specific XML mappings in it in order to save it as an XML output before uploading to the final destination. I would like to eliminate this step for them if possible.

I know there's no XML output for Alteryx so I tried building my own based on a workflow I found in an old post but then when we tried uploading it, we received a bunch of invalid element errors like this is not a valid Date value, this is not a valid Boolean value, etc

I tried using the Excel template with the XML mappings in it as an additional input file to write my output directly into it but when it goes through Alteryx, I think the XML mappings are getting removed because that output version doesn't work either. 

Is there a way to use the Excel template with the XML mappings in it and output my data into that specific workbook so that the user can simply save it as an .XML file when the workflow is finished?

Thank you in advance!

[OTrieger · Accepted solution]

@EricMartinson 
Why don't you take one XML output that has data in it and use it as a template, replace the data and write it out as XML file?

I did it several times and it always working well.

Input the XML template as csv file so you can get the file schema, replace the data in the, union the data and save the file as XML file.

[EricMartinson]

Ok I will try this. Thank you!