Dynamic Filter in Batch Macro

Gaby

Greetings!

I am new in Alteryx.

I have an excel file containing many tables. each table has an id called table_id, and a record with a unique record_id. All tables have same headers. I would like to run a macro for each table_id. I use the Filter tool to select a table_id and run the workflow for that table. I would like to create a macro that would run for each table_id. I was thinking of a batch macro. I find it hard to configure the filter tool.

I tried to use the Dynamic filter made by @CarlosA (https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Dynamic-Filter/ta-p/9922), but I kept getting errors.

Thank you for your help!

Dynamic Filter.yxzp

LG_Test_1.csv

LG_training1.yxmc

Claje

Hi,

I've attached a zipped up workflow showing how to configure this, as well as a modified version of your batch macro.

I took advantage of some simplification using Dynamic Select to more easily choose what fields to load.

There were quite a few changes that I made to get this working, so I will be happy to answer questions!

claje_multipletableload.yxzp