We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

filtering not working

mnhhs
7 - Meteor

Hi,

 

I am trying to filter the data by CCC_SPEC_CD "305" and Categories 1, 2, 3 & Blanks only as per the below filter:

[CCC_SPEC_CD] = "305" OR
[URGENCY_CATEGORY] = "1" OR
[URGENCY_CATEGORY] = "2" OR
[URGENCY_CATEGORY] = "3" OR
[URGENCY_CATEGORY] = "Blank"

 

But the output is including other CCCs that I don't want and also other categories that I don't want.

 

Any assistance will be helpful. thank you.

 
 
 
 
2 REPLIES 2
gautams091
7 - Meteor

Hi

 

Please check the data type which needs to be String and use the following filter condition 

([URGENCY_CATEGORY]="1" OR
[URGENCY_CATEGORY]="2" OR
[URGENCY_CATEGORY]="3" OR
[URGENCY_CATEGORY]="4") AND
[CCC_SPEC_CD]="305" 

 

 

mnhhs
7 - Meteor

Thank you, its working now. Cheers

Labels