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