Hello
I want to write a formula if where a column named state has NHCTX and NHCIL I want the output to only come out as TX and IL only wout the NHC infront of it.
can you help plz?
In the Formula tool, select your existing field name in the drop-down for Select Column. This will update the value in your existing field.
Chris
IF [state] IN ("NHCTX", "NHCIL")
THEN Right([state],2)
ELSE [State]
Endif
Here is a list of al functions: https://help.alteryx.com/current/designer/functions
@VeronicaElse,
Please see below how you can do it:
Attached the workflow,
If this solve the need please mark it as solved, it will help others,
Regards
Thank you for replying -so the state column will have TX replace NHCTX and IL to replace NHCIL in the same column in the output?
But, I have one column that contains NHCIL and NHCTX and I need them to output on the same column but without the NHC infront of them
