Is there a simple way to extract csv output data into an XML format output in Alteryx workflow?
I'm not sure if you've managed to find a solution around this yet.
Here's a macro I downloaded from the Gallery (for some reason I'm no longer able to access it on there) and made some slight modifications to.
If you connect this to an input tool for your CSV report it should save a new file output in XML format.
@another2 I believe there is no native function of Alteryx can output XML format.But this post gives a macro that might help. Just give a try.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/XML-Output/td-p/466203Update:
I am sorry but I failed with the link of macro in above link.
The macro hasn't been updated to the new gallery. What kind of .xml are you trying to output to (ie raw or named?)
apathetichell I'm trying to output a finished data or analyzed data report that's currently a csv output. so I would like a raw or named .xml.
Hi @another2 - I attached a macro that used to be on the Gallery. Hope it will help.
Hopefully that will work for you - but you should throw in a find/replace to sub out the escape characters for the codes listed here:
https://www.ibm.com/docs/en/was-liberty/base?topic=manually-xml-escape-characters
Tip - replace & first - so you don't replace it twice...
Hi @artapaThank you for your response, I tried that but it doesn't seem to update my report to xml
Hi @ArtApaThank you for your response, I tried that but it doesn't seem to update my report to xml
Thank you very much, this is great
be aware, This does not work for me if I run the workflow with the AMP engine enabled. It will only run with the AMP engine turned off. Workflows by default have the AMP engine turned on.
This has to do with the way some tools will order items with the AMP engine and the ordering of the XML comes out incorrect.
