Hi. I would like to select all rows based on a condition in Alteryx workflow.
If PLAN_STATUS column has a value "P" and TOT_ASSETS column has a value "0" at the same time, do not show these rows and show everything else.
For example if original table is:
PLAN STATUS TOT_ASSETS
P 10
A 10
A 0
P 0
I want to see:
PLAN STATUS TOT_ASSETS
P 10
A 10
A 0
How can I implement this in Alteryx Workflow?
Solved! Go to Solution.
Hey @menessert, you’ll be able to do this with a filter tool, with the following expression:
[PLAN_STATUS] = ‘P’ AND [TOT_ASSETS] = 0
Desired output will come out of the bottom (false) output anchor! Any issues let me know.
Thank you! I did not know about how F portion worked :)