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?
Solved! Go to Solution.
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?
Am looking something like - IF ([COL A] = 1) = (COL B = 1X & 1Y) THEN 'TRUE' ELSE 'FALSE' ENDIF. Is that possible?
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
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