Case using Between with Text

Options

• Mute

MRasmussen Member

April 2022 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?

0

Answers

• 

  MRasmussen Member

  April 2022

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

  1