Unable to lookup empty cells

Question

I want to create a column “IA Notes” to fill up the information like “Failed, no info” or “OK, with info”.

I was trying to use the Conditional formula to look up the empty cells from the Input Date (2) but it seems not working properly.

I do expect to see the output at Formula (25) – to have new column “IA Notes” and filled up with information like “Failed, no info” or “OK, with info” after confirming the empty cells from the columns of the Input Data (2) like “Description”, “Manager” and “Employeetype”.

I somehow stuck at Formula (25) and need help to check whether the conditional formula I used is correct? Or if I have missed some steps?

Unable to lookup empty cell in Excel.docx

ncrlelia · Accepted Answer

Hi @DouglasEKL,

Based on your screenshot, you are missing a 'THEN' for the 2nd ELSEIF.

Assuming that you have set empty values to zero for all the 3 fields, then you can just add a THEN after the 2nd ELSEIF.

So it will be like '.....ELSEIF [employeetype] = 0 THEN 'Failed, no info' ELSE 'OK, with info' ENDIF'

If you like you can use OR operator to shorten the formula to the following:

IF [Description] = 0 OR [manager] = 0 OR [employee] = 0

THEN 'Failed, no info'

ELSE 'OK, with info'

ENDIF

Hope this helps.

Cheers,

Lelia

apathetichell · Accepted Answer

you are testing if strings are equal to 0 (the number). You want to use the test isempty([description]) to test if is null/empty. You need to include the elseif as @ncrlelia correctly pointed out - but Alteryx won't let you even get that far because of the string comparing to number issue.

Also - please please please don't post pictures in word files. Most of us would prefer actual data/workflow or at the very lease screen grabs and lots of them - showing configuration settings on the problem tools.

DouglasEKL · Accepted Answer

Thank you very much @apathetichell and @ncrlelia i managed to get the result/output i want. It works fine with the formula below:

IF IsEmpty([Description]) THEN 'Failed, no info' ELSEIF IsEmpty([manager]) THEN 'Failed, no info' ELSEIF IsEmpty([employeetype]) THEN 'Failed, no infor' ELSE 'OK' ENDIF

apathetichell · Accepted Answer

Good to hear - can you make sure to mark our answers as solutions? Thanks!