Creating a macro for a frequently used process

We're just starting with Alteryx and have begun to develop a few workflows. We have a process that creates a filename based on today's date and then gets that HR file from a network folder. We then import the data from that file with a Dynamic Input and then format some of the data.

We will need to use this process in many future workflows, so we'd like to make a macro for simplicity. I've discovered, though, that I cannot convert the Directory input object to a Macro Input. Is there any way around this?

Input

Macros

Accepted answers

IraWatt

@EEnglish2 The second you add a macro output it becomes a macro file. You can save it and distribute it. If you save it to your macro folder users can access it from there ribbon else if you can just insert it like this if its already open:

All comments

IraWatt

Hey @EEnglish2,

Assuming you want to be able to change the directory your looking at you will want something like this:

The control parameter passes the directory location then the action tool will update where the directory tool looks. The Alteryx community has some great videos on batch and other macros if you haven't checked them out.

HTH,

Ira

Example macro.yxmc

EEnglish2

The directory is static. The HR reports will always be there.

IraWatt

@EEnglish2 Then there is no need for it to be an input as its static, the user doesn't need to input anything.

EEnglish2

That makes sense. So then how can I bundle this to make it easier to add to other workflows?

IraWatt

DataNath

Was going to say the same as @IraWatt (no need for a macro input) - I actually built something similar this week! Mine basically checks the folder for the most recently created and then pulls it then outputs it into my workflow for use. In your actual workflow you'll just plug the output into your next steps with the file you want.

ChrisTX

From the Interface category, add a Folder Browse tool and connect it to your Directory tool. Alteryx will add an Action tool, and the default action (Update Directory with Folder Browse) is what you'll need.

Then choose menu option View > Interface Designer and click the magic wand on the left to test your Macro. Click the Browse button and choose a folder, then click Open Debug. Alteryx will create a new Debug tab that you can then run like a regular workflow. The Debug tab has all of the interface elements removed, and the tools connected from the Action tools are updated to reflect the results of the action tools, before you clicked the Debug button.

Macros can be quite a challenge to master. The Video Training Index https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161 used to have several videos on macros. Not sure why so many of the videos are now gone.

Chris

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335