Nested If

Hello,

I have 3 columns - "Hours" (string) and "Login_Time" (time) and "Logout_Time"(time).

I want to get an outcome that if "Login_Time" is more than 08:00:00 then I should get "Late Login". If "Logout_Time" is blank then "No Logout" and if "Hours" are less than 9 then it should show "Early Logout" and if "Hours" are more than 12 then it should show "Incorrect Logout" and if none of the above then "-".

Please also confirm whether I will need to change the formats (string)(time) for any of the columns for the calculations to work? Appreciate your help.

Workflow

Time Series

Accepted answers

Hi @danishrizvi ,

Attached in one example showing how to accomplish it.

The only thing you need to change to make a cleaner if statement is to change the hours to integer or double if decimal.

Let me know if that works for you.

Best,

Fernando Vizcaino

2020-01-31 Nested If.yxmd

You are missing the column name in your elseif statements

IF IsNull([Column Name])

THEN "N/A"

ELSEIF [Column Name] = "Not Applicable"

THEN "N/A"

ELSEIF [Column Name] = "null"

THEN "N/A"

ELSEIF [Column Name] = "none"

THEN "N/A"

ELSE [Column Name]

ENDIF.

All comments

In Alteryx, there is the traditional if statement:

IIF(evaluation statement, true value, false value)

But there is also a conditional statement that I think is a lot cleaner than using nested IIF statements

IF evaluation statement

THEN value

ELSEIF second evaluation statement

THEN value

ELSEIF third evaluation statement

THEN value

ELSE value

ENDIF

Hi @danishrizvi ,

Attached in one example showing how to accomplish it.

The only thing you need to change to make a cleaner if statement is to change the hours to integer or double if decimal.

Let me know if that works for you.

Best,

Fernando Vizcaino

2020-01-31 Nested If.yxmd

hi @danishrizvi

What about multiple conditions, i.e. Late Login and Early Logout?

Dan

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703