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

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.