Batch Macro Using Conditional Statements to Assign Category

Question

Goal: Go through every row and assign a 'category/population identifier" to each record. It is possible for a record to be assigned to many populations, so when I drafted the flow I did not 'group by' my goal is to stack all this data on top of itself. The final output will allow me to split the master file by category and deliver it out to relevant groups. This article started me off.  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Loop-through-multiple-conditions/td-p/313379

I get a configuration error each time I try to do this. This is my first macro so any help would be greatly appreciated.

Macro to Assign Population.yxmc

Macro Input to Identify Population.yxmd

Raw Data for Community.xlsx

Promo Conditions.xlsx

clmc9601 · Accepted Answer

Hi @MJAGNARAIN,

You are so close! I made two minor changes, and I believe it works now. I zipped and attached the workflow with the changes. The macro currently evaluates each record twice (once for each condition) so the output contains twice as many records as the input.

Here are the changes I made:

1. Removed the  =  at the beginning of the promo conditions

2. In your second Macro action, you don't need the quotation marks. Just [#1] gets the job done since you are using an IF statement instead of writing the condition in the field like in the post you linked originally.

Hope this helps! Congrats on your first macro!