I'm relatively new to Alteryx and am working my way through these. I wonder if you might help me on an alternative solution.
I missed your super-simple: "SC"+[Safety Code], probably because I over-thought it.
I had originally tried, unsuccessfully, to use PadLeft, using variants of:
IF Length([Safety Code]) == 6
THEN PadLeft([Safety Code], 1, 'C')
ELSE [Safety Code]
Then repeated for "S"
Any idea why using PadLeft didn't work?