Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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