what is the best formula to use to convert codes to actual text; example; A = Excellent, B = Average, F = Fail, etc.? within Alteryx
Happy to help : )
Please mark the post as solution
Hi @vern ,
I built the attached solution that does what you want using either an IF statement or a Switch function.
Ask me if you need more details.
Cheers,
Jean-Baptiste
Two options either using a switch statement:
Switch([Code],[Code], "A","Excellent", "B","Average", "F","Fail")
Alternatively, look at using a Find and Replace tool which is a good fit for this
@vern Maybe the Find and Replace is suitable for your requirement.
i'm very new to Alteryx and these formulas...
the code, code
i'm assuming the first code is the field in the table ("A") and the 2nd code is the verbiage ("Excellent"); can the 2nd code be a new field being created or is it replacing the first field? i hope this makes sense.
so, this makes more sense to me than the switch; however, the fields are actually being changed to the new values, correct?
