{Urgent} renaming field based on condiion

[AnanditaShankar]

Hi. I want to replace "None" in GSAP_PLANT_MAPPED column with Y01Q based on the condition that LOC_NM_REMAPPED is CHATTANOOGA, TN-LINCOLN TERMINAL. i am using formula tool where I used below expression IF [LOC_NM_REMAPPED]= "CHATTANOOGA, TN-LINCOLN TERMINAL" && [GSAP_PLANT_MAPPED]="None" THEN [GSAP_PLANT_MAPPED]="Y01Q" ELSE [GSAP_PLANT_MAPPED] ENDIF

But this is not working. Any help is appreciated. thanks in advance

[Towers · Accepted solution]

@AnanditaShankar 

Heres one way 

[BS_THE_ANALYST]

@AnanditaShankar  check your IF statement:

Your logic is all correct, you just need to understand that after the THEN statement, you don't need to tell it: Column = Value. Just write the value you want to fill in, it understands already what column it is working on because you tell it here:

i.e:

 IF [LOC_NM_REMAPPED]= "CHATTANOOGA, TN-LINCOLN TERMINAL" && [GSAP_PLANT_MAPPED]="None" THEN "Y01Q" ELSE [GSAP_PLANT_MAPPED] ENDIF

[AnanditaShankar]

Thanks . It worked

[AnanditaShankar]

Thank you @BS_THE_ANALYST  @Towers