In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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