Hello,
I have a status code column that contains values for the following values:
ACTIVE
CANCELED
TERMINATED
AC
CA
AC and CA stand for ACTIVE and CANCELED respectively.
I need a formula to replace the AC and CA to show ACTIVE and CANCELED. I tried the following expression for ACTIVE:
Replace([MBRSHP_STS_CD], "AC", "ACTIVE"). I get the right value for AC to appear as ACTIVE, but the ACTIVE values now show as ACTIVETIVE.
Is there a way for me to tell Alteryx to look for only "AC," and not the 'AC' in ACTIVE?
Thank you.
Solved! Go to Solution.
Thank you Marquee.
Thank you Joe! Your solution worked for me.