Filter Tool not working

I gathered the Max of two columns (by using the summarize tool) so they are called [Max_Total] and [Max_F9]. I want to use the filter tool for the information to filter through "T" if they match and "F" if they do not match.

I tried using the custom filter:

[Max_Total]=[Max_F9]

When the values match it filters it through the "F". I changed one of the values for them to mismatch and it filtered the mismatch values through "F". So it is filtering them both, whether they match or do not match through the "F".

I also tried this one:

[Max_Total]!=[Max_F9]

And it filters both matching and mismatching values through "T".

I also tried with the

IF [Max_Total]=[Max_F9] THEN "T" ELSE "F" ENDIF

and viceversa and it still does not work. Someone help!

Help

Accepted answers

All comments

ChrisTX

Can you post a workflow with sample data?

If you're trying to specify True or False in a Filter tool, use:

IF [Max_Total]=[Max_F9] THEN 1 ELSE 0 ENDIF

//1 = true

//0 = false

isacaso18

Hello I tried this and look

It is filtering it through "F" when it should be filtering through "T".

TheOC

hey @isacaso18

I believe i have created the filter how you need it, however its slightly hard to understand the problem. Please have a look at my solution, and let me know if this works.

Thanks,
TheOC

ISACASO18.yxmd

isacaso18

Hello,

it is still displaying it as False.

TheOC

Are both of your datatypes numeric / doubles?

Can you package a workflow with your data (or, just this row of data) so i can test with the exact same setup?

Cheers,
TheOC

Luke_C

Hi @isacaso18

Add closing parenthesis.

Trim([max_total]) = Trim([max_f9])

patrick_digan

@isacaso18 Unfortunately, alteryx doesn't always show you the actual number that is saved behind the scenes. I suggested 5 years ago that they add an indicator to alert the user and show the actual number. https://community.alteryx.com/t5/Alteryx-Designer-Ideas/visual-indicator-actual-value-anytime-displayed-numbers-are/idi-p/45130

Off the top of my head, you might want to round both numbers Round(max_Total,.01) or take the abs of the difference and make sure that it's really small ABS(Field1-Field2)<.0000001

isacaso18

ChrisTX

More people may be able to help you, instead of guessing at a possible cause, if you could upload a workflow with sample data.

Each field's data types make a significant difference in how Alteryx processes the data.

My first suggestion was:
IF [Max_Total]=[Max_F9] THEN 1 ELSE 0 ENDIF

When you add double quotes around the 1 and 0, Alteryx will act differently.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335