We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Can a macro be added as a tool at the end of a workflow?

paulb1
8 - Asteroid

Hey Everybody!

 

I found a great macro, and I run it separately from the workflow I use to produce the original output file.  The macro converts a .csv to .xml.  Can I add the macro at the end of the workflow so it all runs at once?


Thanks,

 

Paul

7 REPLIES 7
DataPrepChad
10 - Fireball

Hi @paulb1,

 

I don't see why not, but if you are comfortable it may be worth cracking open the macro to see if you can simply convert the input parameter to a Macro Input.  If that's the case, you should just be able to then use that macro at the end of your workflow as any other Output Data tool.

 

Can you provide a link to the macro?  Happy to take a look.

 

~ Chad

dataprepu.com

paulb1
8 - Asteroid
DataPrepChad
10 - Fireball

Oh, cool.  You should just be able to connect your data stream to the input of the tool, then select the File Mode option to specify your XML output file name.  

XMLOutput.png

paulb1
8 - Asteroid

I've got the macro in my workflow, but how do I get it to automatically fire off after my .csv file has been created?  I get a missing incoming connection.  ??

 

Capture.JPG

 

 

paulb1
8 - Asteroid

Nevermind.  I just created an input to bring my .csv in and connected it to my macro.

 

Thank you a million times for the help.

DataPrepChad
10 - Fireball

Hey @paulb1, do you need both the .csv and .xml?  If so, you should also be able to just branch off a separate data stream from your Select tool to create the .xml directly.  

paulb1
8 - Asteroid

Hi Chad,

 

No, just need the .xml.  The .csv was so I had something to convert.

Labels