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

Filtering data

BenMurrells
8 - Asteroid

Hi All

 

I'm trying to exclude data from a dataset based on just two parameters.  To clarify I need both parameters to be fulfilled in order to exclude from the dataset.  For example if Entry Date and  Code match the parameters below then exclude from data.  I can't do this as a step formula pattern because it will exclude data on one field only and then the next.

 

Entry Date should be before 1st January 2023

Code should be = 0

 

Can anyone point me in the right direction for the formula expression?

 

Any help appreciated.

 

 

1 REPLY 1
DataNath
17 - Castor
17 - Castor

Hey @BenMurrells, if I'm reading this right then you'll be able to just put both conditions in a filter using an AND operator and the records you're excluding will come out of the top (True) anchor, so you'll be interested in the bottom (False) results. Attached a workflow below for reference using this expression:

 

[Date] < '2023-01-01'
AND
[Rand] = 0

 

Where Date and Rand are just 2 fields I've made to mimic your Entry Date and Code fields.

 

998.png

Labels
Top Solution Authors