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.

Recompile XML after using the XML parse tool

Carlos_Tovar
7 - Meteor

Hello,

 

I am trying to edit the xml of another workflow to mass update some tools but I need to parse out the xml then re compile it exactly how it was for the file integrity to stay intact and avoid missing xml characters or the  xml wont run as a workflow.

 

I tried some macros and exporting as a flat file but both miss characters the xml needs to run and it fails...is there a way to do this in alteryx or use normal tools to recompile without missing any characters for the xml to run as a workflow?

 

Here Im just trying to update the select records tools and ranges  en masse then put them back into the xml and export it.

 

Unfortunately I cant attach the workflow 

 

Thanks 

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @Carlos_Tovar 

 

This is a great topic to understand how to properly change the XML of workflow files, just take a look on how he replace the fields and save the XML in the end:

Chained Alteryx Analytic Applications - Alteryx Community

Carlos_Tovar
7 - Meteor

Thats not really a good solution for what im trying to do and it doesnt work in several instances...So alteryx doesn't have a method to simply reverse what the xml parse tool did ? 

apathetichell
20 - Arcturus

You don't want to do this in the XML tool - you want to edit it as a text file and then save it.

 

the XML tool is designed to take in semi-structured XML and then change it into a structured traditional database row/field/value grid. Once structured there is no out of the box Alteryx tool to rebuild your XML into a semi-structured XML appropriate output. This is true not just for Alteryx workflows XML - but all XML.

 

There is no "simple" about it - and this is true for XML and JSON and true outside of Alteryx. rebuilding semi-structured is always more complicated than taking it apart.

Carlos_Tovar
7 - Meteor

Yup I tried to bring it in as a flat file and it did not work it stripped alot of the necessary characters, I found a simple solution in Python thanks. 

Labels
Top Solution Authors