SOLVED
Compare numbers in 2 columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Disey
6 - Meteoroid
09-03-2024
08:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
TUSHAR050392
11 - Bolide
09-03-2024
09:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
09-03-2024
11:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Perfect, many thanks 😁
