"Greater/Lesser Than" <> Formula to return value
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
New to Alteryx. I need to translate a large excel sheet with formula.
In the spreadsheet the user has used greater/lesser than formula to check against several columns and return a specific value in my case my chosen word is "All-Birds".
A simple example below of what the user has done and I am unsure how to put into a formula.
In the PlaceAnswerBelow column, they used <> to check if there is a value in each of the Animal columns.
The Animal1,2,3,4,5 columns may or may not contain content.
So, is the use of <> equation the best way forward or is there a better way of getting the result.
Huge thanks in advanced.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @PamG,
If you want to check if a column contains anything you can use the isEmpty() function in Alteryx for instance isEmpty([Animal2]) would return true.
If you want to check something is not equal to something you can use the != syntax eg. [Animal2] != "All-Birds"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HIya @IraWatt, Thanks for this but am still confused and don't know how to put this into a formula. Would you be able to provide a yxmd file, please
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@PamG I have attached a filter and formula example. Could you give a table example of what you want to happen?
The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IraWatt thanks so much for your help in providing us with flow and formula - it worked!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @PamG glad it helped 😄 have a good one !
