topic Re: Filter Tool in Alteryx Designer Desktop Discussions

Filter Tool

cstafford — Wed, 13 Jan 2021 16:35:53 GMT

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.

Re: Filter Tool

cstafford — Wed, 13 Jan 2021 16:39:56 GMT

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

Re: Filter Tool

Kenda — Wed, 13 Jan 2021 16:45:04 GMT

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