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

 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels