Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!