Using Formula Tool - How to compare 2 columns with condition?

Dear All,

I have situation where need to compare 2 columns with conditions in both the columns, refer the below table. Please urge how I can write the formula in the Formula tool to get the output in simple way.

A	B	Output
01	1X, 1Y	TRUE
02	2A, 2B	TRUE
03	3D, 3E	TRUE

Without using any mapping?

Datasets

Data Investigation

Accepted answers

ShankerV

Hi @ravikumar060987

I have amended the formula as you need the result as False if the condition is failed.

IF [A]="01" AND Contains([B],"1X") AND Contains([B],"1Y")
THEN "TRUE"
ELSE "FALSE"
ENDIF

Many thanks

Shanker V

All comments

FinnCharlton

Hi @ravikumar060987 , what logic are you using to get this output? What comparison are you doing? Can we have an example of when the output should be true and an example of when it should be false?

ravikumar060987

Hi @FinnCharlton

Am looking something like - IF ([COL A] = 1) = (COL B = 1X & 1Y) THEN 'TRUE' ELSE 'FALSE' ENDIF. Is that possible?

ShankerV

Hi @ravikumar060987

This formula will help you. Kindly check whether this you are looking for,

IF [A]="01" AND Contains([B],"1X") AND Contains([B],"1Y")
THEN "TRUE"
ELSE null()
ENDIF

Many thanks

Shanker V

Using Formula Tool - How to compare 2 columns with condition.yxmd

ShankerV

Hi @ravikumar060987

I have amended the formula as you need the result as False if the condition is failed.

IF [A]="01" AND Contains([B],"1X") AND Contains([B],"1Y")
THEN "TRUE"
ELSE "FALSE"
ENDIF

Many thanks

Shanker V

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703