Excel formula to alteryx

[Crypto_raccoon]

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?

[Kenda · Accepted solution]

Hey @Crypto_raccoon 

Instead of ISBLANK(), try IsEmpty(). Also, in Alteryx, use iif for conditional statements like this.

Hope this helps!

[Emil_Kos]

Hi @Crypto_raccoon,

I believe it would be 

IIF(IsEmpty([Column name]), 'No', 'Yes')

[MK_Alteryx411]

In the event this still doesn't work, use the cleanse tool to eliminate leading & trailing whitespaces and then use the IsEmpty() method again.