need some help in converting the if condition...

Raj_007

Hi All,

I have this IF condition which is from another tool.. i need to convert this into Alteryx IF condition

If([DR2 - Last Valid Date]< [SR1 - Last Valid Date] and [SR1 - Test Passed] = 'Yes' , - This is the condition

[SR1 - Last Valid Date] +365 , --This is the THEN part

--This is the ELSE Part

If([DR2 - Test Passed] = 'Yes',

[DR2 - Last Valid Date]+365 ,

'No Test Date')

)

Developer

Accepted answers

pedrodrfaria

Hi @Raj_007

This is how you would write this in Alteryx. I'm assuming that the columns with the name Date contain date information.

IF [DR2 - Last Valid Date] < [SR1 - Last Valid Date] and [SR1 - Test Passed] = 'Yes'

THEN datetimeadd([SR1 - Last Valid Date],365, 'days')

ELSEIF [DR2 - Test Passed] = 'Yes'

THEN datetimeadd([DR2 - Last Valid Date], 365,'days')

ELSE 'No Test Date'

ENDIF

I attached a workflow for educational purposes.

Pedro.

need some help in converting the if condition....yxmd

Qiu

@Raj_007
As @pedrodrfaria explained, we need to be careful abou the data type.

And I think it is better to do some Data Cleansing first based on your real business workflow.

New Workflow7.yxmd

All comments

pedrodrfaria

Hi @Raj_007

This is how you would write this in Alteryx. I'm assuming that the columns with the name Date contain date information.

IF [DR2 - Last Valid Date] < [SR1 - Last Valid Date] and [SR1 - Test Passed] = 'Yes'

THEN datetimeadd([SR1 - Last Valid Date],365, 'days')

ELSEIF [DR2 - Test Passed] = 'Yes'

THEN datetimeadd([DR2 - Last Valid Date], 365,'days')

ELSE 'No Test Date'

ENDIF

I attached a workflow for educational purposes.

Pedro.

need some help in converting the if condition....yxmd

fmvizcaino

Hi @Raj_007 ,

Alteryx doesn't understand the sum of dates + numbers as in here ([SR1 - Last Valid Date] +365), that is why you need to use a specific function to achieve what you are looking for, exactly as @pedrodrfaria wrote.

To learn more about conditional statements and dates, check the following links.

https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910

https://help.alteryx.com/current/designer/datetime-functions

Best,

Fernando Vizcaino

Qiu

@Raj_007
As @pedrodrfaria explained, we need to be careful abou the data type.

And I think it is better to do some Data Cleansing first based on your real business workflow.

New Workflow7.yxmd

Raj_007

Hi Pedrodrfaria, fmvizcaino, Qiu - Thank you so much for your input, really appreciate your time

Unfortunately, those columns are not DATE datatype they are strings as they have Gap, N/A in it.

Does this mean i cannot check if Date1 < Date2 within the string using the DateFormat and DateParse... iam almost there

while testing this is what i noticed.. the < is not getting worked

IF [Band Temp] ='1' AND [DR2 - Last Valid Date] NOT IN ('Gap','N/A') AND [SR1 - Last Valid Date] NOT IN ('Gap','N/A')
AND DateTimeFormat(DateTimeParse([DR2 - Last Valid Date],'%m/%d/%Y'),'%m/%d/%Y') < DateTimeFormat(DateTimeParse([SR1 - Last Valid Date],'%m/%d/%Y'),'%m/%d/%Y')
THEN '1'
Else 'No Test Date'
ENDIF

In the output column all i see is No Test Date - when i worked on each one by one i found that the hilighted in color is not working

how do i approach this way

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703