This content has been marked as final. Show 4 replies
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:
[name] AS [event_type.name],
SQL SELECT "event_type_id",
CASE WHEN "is_planned" = 1 THEN 'Planned' ELSE 'Unplanned' END
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!