community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

FILTER OPTION BUG : "AND" "OR" FUNCTION

Meteoroid

Hi,

 

My "AND" function does the "OR" functionality & "OR" function does the "AND" functionality. Attaching a sample flow... I think there is some kind of bug in the new update.

ACE Emeritus
ACE Emeritus

I have version 11.0 and all rows correctly go to the False of the filter.  Are they not for you?

Alteryx
Alteryx

I've just run your module on v11.5 and it appears correct. All lines correctly going to the False output.

Meteoroid

if filter is "[EU]!=8000 OR [MM]!=0" then T should have [EU]=1 [MM]=1

                                                                 F should have remaining rows

 

If filter is "[EU]!=8000 AND [MM]!=0" then T should have 1) [EU]=1 [MM]=1

                                                                                            2) [EU]=1 [MM]=0

                                                                    F should have remaining rows

 

 

But that's not the case...

Alteryx Certified Partner
Alteryx Certified Partner

I'm working with the latest version of Alteryx and to me the logic seems correct.

 

I've attached an image of the logic calcs with your sample data.

 

IMAGE.PNG

 

I get the records split out as in column G when I run the alteryx workflow with the respective logic.

 

Can you confirm you are expecting the same results here or are you misinterpreting how the logic should view the data?

 

Ben

Alteryx Certified Partner
Alteryx Certified Partner

In the sample data you give it is also worth noting you don't have a record that is

 

[EU]=1 [MM]=1

 

Ben

Meteoroid

I am getting the same results when calculated in excel. Looks like I misinterpreted the logic. Thanks for all the quick responses... 

Labels