how do I dynamically update my filter in Alteryx?

[ryanzhang487]

Hi, I have a filter in my Alteryx workflow which exclude certain values(see pic on the left), I would want this list to be updated dynamically occasionally from a excel file that I receive (see pic on the right), instead going into the Alteryx filter to manually update, is there a dynamic way for me to do this work?

Thank you for your help

                               

[Felipe_Ribeir0 · Accepted solution]

Hi @ryanzhang487 

An easy way of doing this is by joining your main data with this external excel file and get just the L anchor. 

[Felipe_Ribeir0]

But if for some reason you need/want to go with the dynamic filter, here is how to do it using a macro:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Dynamic-Filter/ta-p/9922