"Advanced Filtering"

[daveyc3000]

So, I use a lot of advanced filtering in Excel/VBA

Is there a way to feed Excel files into Alteryx for filtering or make a filtering table in Alteryx instead of writing out a long-winded statement under Custom Filter? I have three cases in the file attached:

1) column A...list is really long, I would not want to type that all out as filter statement in the Filter function of Alteryx

2) column C....what about wildcards?  I would assume * would work in Alteryx, but again, I would not want type that all out

3) columns E and F...here is a AND condition...e.g., filter for "BA" AND ABC code = 3401 (because there could be BAs with other ABC codes, but I dont want)  ....can be done in custom filter, but what if this list gets really long?

[Matt_D]

Hi @daveyc3000 

I believe you would want to use:

1) Join Tool

2) Find Replace Tool

3) Join Tool

Happy to show practically if required. Attached, I was being lazy.

Matt