community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Macro: Update Filter Using a List of Input

Meteoroid

Hi, 

 

I have a workflow that I have to run for every organization code listed on an Excel file (will be my input for the macro). 

 

I've completed the workflow for one specific org, so I'm trying to use Macro to update the filter in the beginning of the workflow. It looks like this right now: 

Capture.PNG

 

My questions is, how do I configure the Macro input properly, so I can use a Excel file as input and run the entire workflow for each of the codes listed (I'm using 3 as a test at the moment).

Perhaps there's better way to set up the beginning of the workflow... Any directions would be greatly appreciated! 

 

Thank you. 

Alteryx
Alteryx

Hi @Yijen ,

 

If you create a batch macro, then you don't need the filter tool as the batching process will essentially be the filter for you. Attached is an example of a batch macro without the Control Parameter - 

 

withoutbatchandbatchmacro.JPGWithout Batch Macro vs Batch Macro

 

Insider the blue Batch Macro (no filter needed) - 

insidemovingsummarize batch macro.JPG

Your Group By column = INPUT_ORG_CODE

Alteryx Certified Partner

Hi @Yijen !

 

Please check this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-update-a-list-box-and-filt...

 

We recently walked through this exact question.
If you need anything else, please feel free to reach out!

You're very close!

Meteoroid

Hi @JordyMicheal 

 

I modified my workflow based on the post you just shared, but the OrgCode on the filter dint seem to be replaced by the Action Tool. 

Here's how I config my Action Tool:

Capture.PNG

I also tried to put only OrgCode in the box of Replace a specific string, but still, the OrgCode didn't get picked up by the filter. 

Any idea...?

 

Thank you! 

Highlighted
Alteryx Certified Partner

Hi @Yijen 

 

You'd what to leave the box checked and replace "OrgCode" with the quotes.

 

But reading what you are doing, it looks like you're trying to get a question as an input?

Is that correct?

Labels