Condition on a Column

Hello All,

I have two columns with rows information coming in as date and text format, I am trying to apply a case statement, if either of the columns have date information then It should flag that as Yes, if not with No.

for example design review or code review column have date then it should flag as yes other wise no

Below shown is the sample data

Thank you

Avanti

Datasets

Date Time

Accepted answers

AngelosPachis

Hello @Avanthi ,

You can create that If statement inside a formula tool. That statement will be:

IF REGEX_Match([Design Review], "\d{4}-\d{2}-\d{2}") OR 
REGEX_Match([Code Review], "\d{4}-\d{2}-\d{2}")
THEN "Yes"
ELSE "No"
ENDIF

That RegEx match embedded formula goes to each one of the designated fields and checks if the values within them comprise of four digits followed by a dash, followed by two more digits, followed by a dash followed by two more digits.

Essentially if something has the yyyy-mm-dd format.

The output looks something like this

Hope that helps,

Regards,

Angelos

All comments

AngelosPachis

Hello @Avanthi ,

You can create that If statement inside a formula tool. That statement will be:

IF REGEX_Match([Design Review], "\d{4}-\d{2}-\d{2}") OR 
REGEX_Match([Code Review], "\d{4}-\d{2}-\d{2}")
THEN "Yes"
ELSE "No"
ENDIF

Essentially if something has the yyyy-mm-dd format.

The output looks something like this

Hope that helps,

Regards,

Angelos

fmvizcaino

Hi @Avanthi ,

There are numerous ways but I've found this the easiest one. To duplicate both fields changing its format to date and verifying its content.

Best,

Fernando Vizcaino

2021-01-05 Condition on a Column.yxmd

Avanthi

It worked, thank you @AngelosPachis , @fmvizcaino

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703