Hello,
How to solve this following issue -
if Column A contain 123 then
if Column B contain XYZ then -------------
Replace Column C into "Only EXP"
¡Resuelto! Ir a solución.
something is wrong on this equation i think else and endif doesn't go together. i tried it but get error.
Hi @ksarker ,
@TheUdbhav 's formula seems to be correct.
Column C= IF [Column A]='123' and [Column B]='XYZ' THEN 'Only_EXP' ELSE '' ENDIF
Please make sure you use TWO quotations between ELSE and ENDIF, not one double-quotation.
For your reference, I attach the same workflow, which works on my PC.
Good luck.
Thanks Yoshero but its didn't solve my last part of the problem. first two parts are ok then replace didn't work. if condition for column A and B are true then i want to replace entire column C into "EXP Only" and i am missing this replacement part.
@ksarker drag a formula tool onto the canvas. In the formula tool select the column "EXP Only".
Use @Yoshiro_Fujimori 's logic:
IF contains([Column A],'123') and contains([Column B],'XYZ') THEN [Column C] ELSE '' ENDIF
@BS_THE_ANALYST thank you, the requirement is confusing 😀
My Question was if Column A = ABC then Column B= XYZ then replace anything from Column C into "EXP Only" (meaning how to update Column C for line 1 and 3 with "EXP Only")
Column A | Column B | Column C |
ABC | XYZ | 123 |
CHDG | XYZ4 | 50 |
ABC | XYZ | 458 |