Selecting rows based on a condition

[menessert]

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?

[DataNath · Accepted 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.

[menessert]

Thank you! I did not know about how F portion worked :)