community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Multi Field Filter

A way to filter multiple fields by the same variable.

 

For Example. If I have multiple columns that have Names, email addresses, etc. I want to filter all fields so that each field Does Not Contain = "Test"

 

If this already exist, my apologies. Just point me in the right direction Smiley Wink

2 Comments
Aurora
Aurora

Hey @shaunbeckett

You can do this in two tools relatively quickly:

 

a) set up a formula that returns a new column with a 1 if the value exists in one of the fields, and a zero if not

b) simple filter on this field

 

You can do this in a single tool by doing a custom filter

 

Or you could do this generically by transposing the data and then doing this as a simple filter.

 

On this particular case - it may be worth posting your particular use-case onto the discussion thread under "Data PRep and Blending" and then the community will very quickly get you a solution.  

Here's a guide that may help you get the fastest possible answer: https://community.alteryx.com/t5/Welcome-to-the-Alteryx-Community/Posting-for-fastest-possible-solut...

 

Meteoroid

Thanks Sean! Sorry I should have prefaced it with "I have the solution already, but... it would be nice to have" kind of thing. The idea would be to enter the specific string/strings you would like to filter on and then select the fields you would like to apply this filter to. Again, I just thought it would be nice to have.

 

Thanks for the feedback!