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.
