Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

Conditional filtering in formula tool

Highlighted
7 - Meteor

Hello,

 

I have two fields with percentages. I would like to say that if either Field 1 or Field 2 is not equal to 100, delete (filter,disappear) the row. I would like to do this specifically in the formula tool.(I've already done it using filter module).

 

Field1         Field2

100              100                  PASS   (Both fields are 100 pass)

93                100                  PASS  (Field 2 is 100, so pass)

100              95                    PASS (Field 1 is 100, so pass)

95                98                    FAIL (since both values are less than 100)

 

Thank you

Highlighted
Alteryx Alumni (Retired)

You can't delete (or make disappear) a data record using the Formula tool...the Filter tool is the proper tool for doing this.

Now if you mean you would like to create a "flag" field that you can use in a subsequent Filter process (e.g., Y or N), then you would do that in a Formula tool (with basically the same logic you likely already have in your existing Filter tool).

Highlighted
16 - Nebula
16 - Nebula

If they are both percentages (i.e. between 0 and 100):

MAX([Field1],[Field2])=100

would evaluate to TRUE for first 3 cases and false for other

Labels