Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

Field not found / CASE WHEN in Load Script

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!

1 Solution

Accepted Solutions
sunny_talwar

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";

View solution in original post

4 Replies
sunny_talwar

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
Partner - Specialist
Partner - Specialist
Author

Thanks Sunny!

That was it!

agigliotti
Partner - Champion
Partner - Champion

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
Partner - Specialist
Partner - Specialist
Author

Thanks Andrea!