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
5 - Atom

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
5 - Atom

Perfect, many thanks 😁

Labels
Top Solution Authors