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?
Hey @Crypto_raccoon
Instead of ISBLANK(), try IsEmpty(). Also, in Alteryx, use iif for conditional statements like this.
Hope this helps!
Hi @Crypto_raccoon,
I believe it would be
IIF(IsEmpty([Column name]), 'No', 'Yes')
In the event this still doesn't work, use the cleanse tool to eliminate leading & trailing whitespaces and then use the IsEmpty() method again.
