Field not found / CASE WHEN in Load Script

[morenoju]

Hi all,

I have a field in my DB called is_planned that can be a 1, meaning planned, or a 0, meaning unplanned.

As I don't want users to have to remember the codes (1 for this, 0 for that) I thought of using a CASE WHEN in the load script, like this:

[event_type]:

LOAD

[event_type_id],

[name] AS [event_type.name],

[event_category_id],

[is_planned];

SQL SELECT "event_type_id",

"name",

"event_category_id",

CASE WHEN "is_planned" = 1 THEN 'Planned' ELSE 'Unplanned' END

FROM "pems"."public"."event_type";

It is giving me the following error when loading:

The following error occurred:

Field 'is_planned' not found

The error occurred here:

?

I used the CASE WHEN in my load scripts before issue without. Do you see what might be wrong this time?

Also, if you think there's a better way to obtain the same result, don't hesitate to comment.

Thanks in advance!

[sunny_talwar · Accepted solution]

Try this

[event_type]:

LOAD [event_type_id],

    [name] AS [event_type.name],

    [event_category_id],

    [is_planned];

SQL SELECT

    "event_type_id",

    "name",

    "event_category_id",

    CASE WHEN "is_planned" = 1 THEN 'Planned' ELSE 'Unplanned' END AS "is_planned"

FROM "pems"."public"."event_type";

[morenoju]

Thanks Sunny!

That was it!

[agigliotti]

OR

[event_type]:

LOAD

[event_type_id],

[name] AS [event_type.name],

[event_category_id],

if( [is_planned] = 1, 'Planned', 'Unplanned' ) as [is_planned];

SQL SELECT

"event_type_id"

"name",

"event_category_id",

"is_planned"

FROM "pems"."public"."event_type";

[morenoju]

Thanks Andrea!