Start Free Trial

Alteryx Designer Desktop Discussions

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

Comparing data to see if they Equal

AlisonK39
7 - Meteor

Hello! 

 

I'm trying to see across different codes if a rate is the same.  I don't want to take the average, I just want to flag if something is equal (or unequal).  I've attached what I would like to output to be.  

3 REPLIES 3
KSowers
Alteryx
Alteryx

I think this will do what you need. Let me know!

Qiu
21 - Polaris
21 - Polaris

@AlisonK39 

We can use the "Count Distinct" function in the Summarize tool. If the distinct count is 1 than meaning it is equal else Not Equal.

0823-AlisonK39.PNG0823-AlisonK39-1.PNG

AlisonK39
7 - Meteor

These both worked.  Thank you!  

Labels
Top Solution Authors