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.
SOLVED

Compare numbers in 2 columns

Disey
7 - Meteor

Hi

 

I have 2 separate columns containing numbers and I want to filter any numbers in one column that is equal to or more than the number in the 2nd column.

 

Any help in layman terms would be great as I am quite new to alteryx.

 

Thanks

2 REPLIES 2
TUSHAR050392
11 - Bolide

Hey @Disey If the comparison needs to be done on row by row then you can use the filter tool and in that custom filter mention the condition. Column1 >= Column2.

 

Let me know if you need more help

Disey
7 - Meteor

Perfect, many thanks 😁

Labels
Top Solution Authors