ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Custom Filter

Mgstoly
7 - Meteor

I need to remove certain data from a spreadsheet to generate my report,  when I do a custom filter it will only seem to work when i do the AND OR options but I need data to be included for multiple columns  for example I Do Internal category >= Transaction AND Internal Details= Self-Directed but since there are no rows that match that it returns a zero  I need to capture that scenario,  

11 REPLIES 11
DiganP
Alteryx Alumni (Retired)

@Mgstoly I've attached the workflow. Is this what you are looking for? I am looking at the dataset and some Self Directed records are related to a different Internal Category column (other than Transactions / Calculations). Is it okay if thats inside the dataset?

Digan
Alteryx
Mgstoly
7 - Meteor

this one works too, Lots of options to get results with Alteryx 🙂

Labels
Top Solution Authors