Alteryx Designer

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

Custom filter not working as intended?

Highlighted
8 - Asteroid

Hi All,

 

I have a very simple business process involving filtering multiple field in order. 1 input data set, filter involving many categories.

 

Problem is some of the rules involves multiple fields and conditions, the results I'm getting is not as expected.

 

Ex:

 

[LOB] = "FDR"
AND [Job_Category ] !="BUS SUPPORT"
AND [Job_Name] = "Director"

 

results under True showing "Director" for all of [LOB] not just FDR .

 

I want to use a formula tool but I'm not sure how it works in relation to filter. Thanks,

 

-Kevin

 

 

 

Highlighted
5 - Atom

Do you have a sample of the data you are using?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
I agree, to me the logic seems correct, so some screen shots showing the issue or some sample data which show the issue would help us help you!

Ben
Labels