Hey i have a question on how to transform several formulas from excel to alteryx: lets say i have something like =IF(ISBLANK(B2),"No","Yes") in an excel spreadsheet, how do i transform it to alteryx?
Gelöst! Gehe zu Lösung.
Hey @Crypto_raccoon
Instead of ISBLANK(), try IsEmpty(). Also, in Alteryx, use iif for conditional statements like this.
Hope this helps!
In the event this still doesn't work, use the cleanse tool to eliminate leading & trailing whitespaces and then use the IsEmpty() method again.