In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to do a 4 way column compare?

wonka1234
10 - Fireball

How do I compare these 4 columns?

I want a column to show 0 if all 4 of the value columns are equal.

 

wonka1234_2-1657724976784.png

 

13 REPLIES 13
Robin_McIntosh
11 - Bolide

Here you go.

 

Emmanuel_G
13 - Pulsar

@wonka1234  Updated version attached ! 

Emmanuel_G_0-1657732326810.png

 

Emmanuel_G
13 - Pulsar

@wonka1234 ,

 

At the time for me sorry, I had not seen your last message. I update again.

Emmanuel_G
13 - Pulsar

@wonka1234 ,

 

See the attached solution.

 

A bit long but perfectly handles each case for each line as shown in the screenshot.

 

Let me know if it works the way you want.

 

Emmanuel_G_0-1657735191954.png

 

Labels
Top Solution Authors