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"
Based on your data, is column C a numeric column? If so you'll need to change it to a string before you can put string data in it. Use a select tool to convert it, then use the formula from above to set the values. The only change it to retain the values where the condition is false:
IF [Column A]="ABC" AND [Column B]="XYZ" THEN "EXP Only" ELSE [Column C] ENDIF
You were previously using 123 as the value for Column A. If Column A is also numeric, drop the quote marks around the value:
IF [Column A]=123 AND [Column B]="XYZ" THEN "EXP Only" ELSE [Column C] ENDIF
Hi @ksarker..Hopefully I understand your question..You can use calculated field to replace "Only "Column C= IF [Column A]='123' and [Column B]='XYZ' THEN 'Only_EXP' ELSE '' ENDIF
something is wrong on this equation i think else and endif doesn't go together. i tried it but get error.
@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
@ksarker Are you looking for something like this
@binu_acs I think @ksarker has/wants a column called [Only EXP]. If those conditions are met, take the values from [Column C] and put them into the column [Only EXP]
@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")
@ksarker Here is one way of doing this with the multi-field formula tool
with formula tool
