Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter Tool

cstafford
8 - Asteroid

I have a workflow where data is based on zip code, however, I only need particular zip codes based on the particular ask so I use the Filter tool to extract the zip codes I need. Sometimes the number of zip codes I need to focus on is a long list and I use an OR statement to get the required zip codes. What is the best practice to make this easier to avoid retyping in the zip codes in an OR statement every time. Looking for suggestions.

2 REPLIES 2
cstafford
8 - Asteroid

I am going to input an excel file with the Zip Codes then use the Join tool.

Kenda
16 - Nebula
16 - Nebula

Another option would be to use a Text Input tool (to list your desired zip codes) in combination with a join @cstafford 

Labels
Top Solution Authors