This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
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
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...
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.