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
Solved! Go to Solution.
@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
Thanks . It worked
Thank you @BS_THE_ANALYST @Towers