Multiple cases in CASE WHEN

Victoria_G1 · 2024-01-12T17:47:14+00:00

There was an error rendering this rich post.

Hello!

I am trying to include a formula with three possible outputs based on three different conditions inside an ETL but I don't know what's wrong with my formula:

Help is appreciated!

Find more posts tagged with

Accepted answers

ColemenWilson

Should be:

CASE WHEN `Type` IS NULL THEN 'Daily' WHEN `Type Sourced Daily` IS NULL THEN 'Monthly' ELSE 'Mutual' END

You need to drop the extra "ELSE" and use single quotes ' ' instead of double quotes " "

All comments

ColemenWilson

Should be:

CASE WHEN `Type` IS NULL THEN 'Daily' WHEN `Type Sourced Daily` IS NULL THEN 'Monthly' ELSE 'Mutual' END

You need to drop the extra "ELSE" and use single quotes ' ' instead of double quotes " "

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of