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

[paulb1]

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

[DataPrepChad]

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]

Thanks Chad.

https://gallery.alteryx.com/#!app/XML-Output/565bfd4caa690a12542665e3

[DataPrepChad · Accepted solution]

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.  

[paulb1]

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.  ??

[paulb1]

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]

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]

Hi Chad,

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