Case using Between with Text

MRasmussen
MRasmussen Member
in Magic ETL

Hello,

I am trying to use the statement:

CASE WHEN `START_ZONE` BETWEEN 'A' AND 'Z' THEN `PICKUP_TERMINAL` ELSE LEFT(`START_ZONE`,5) END

However, it is not validating for me, what am I missing on this?

Answers

  • MRasmussen
    MRasmussen Member

    It was giving me an error, but when I closed the calculation it accepted it and returned the desired results.

Categories