topic Re: Unknown Statement in QlikView

Unknown Statement

bharatkishore — Wed, 27 May 2015 05:07:35 GMT

Dear All,

I have written the following code and i am getting an error i.e. unknown statement..I don't know where i have been wrong. Can you pls help me on this..I am also attaching the image for your reference.

Classification1:

LOAD nId,

dDateUpdated,

"sys_created_by",

"sys_created_on",

"sys_id",

"sys_mod_count",

"sys_updated_by",

"sys_updated_on",

"u_active",

"u_classification_0",

"u_classification_1",

"u_classification_2",

"u_classification_3",

"u_classification_4",

"u_classification_5",

"u_classification_6",

"u_classification_7",

"u_classification_8",

"u_classification_9",

"u_classification_path",

"u_contract",

"u_external_reference",

"u_filter_tag",

"u_force_path_update",

"u_full_name",

"u_instructions",

"u_name",

"u_number",

"u_parent",

"u_realm",

"u_review_comments",

"u_review_required",

"u_selectable",

"u_service_type",

"u_short_description",

"u_transaction_id",

"u_transaction_source",

"u_type",

"u_visible_downwards",

nDeleted,

"u_customer_integration_id";

SQL SELECT *

FROM "ODS_ITSM".dbo."ITSM_Class_u_classification";

Classification:

LOAD"sys_created_on" as Classification_created_on,

"sys_id" as Classification_key,

u_name as Classification_name,

u_service_type as Classification_S_type,

u_type as Classification_type,

"u_classification_0",

"u_classification_1",

"u_classification_2",

"u_classification_3",

"u_classification_4",

"u_classification_5",

"u_classification_6",

"u_classification_7",

"u_classification_8",

"u_classification_9"

Resident Classification1;

DROP Table Classification1;

Regards,

Bharat

Re: Unknown Statement

tresB — Wed, 27 May 2015 05:18:02 GMT

Put a space after LOAD and try, like:

LOAD "sys_created_on" as Classification_created_on,

Re: Unknown Statement

jagan — Wed, 27 May 2015 05:27:07 GMT

Hi Bharat,

Give space after LOAD keyword.

Classification:

LOAD "sys_created_on" as Classification_created_on,

Regards,

Jagan.

Re: Unknown Statement

danieloberbilli — Wed, 27 May 2015 05:30:39 GMT

Could it be the from sql line?

FROM "ODS_ITSM".dbo."ITSM_Class_u_classification";

Re: Unknown Statement

danieloberbilli — Wed, 27 May 2015 05:31:44 GMT

sometimes the mistake can be in the load / command before the indicated error

Re: Unknown Statement

jonathandienst — Wed, 27 May 2015 05:40:12 GMT

I think the previous posts should address your problem, but I noticed that the LOAD statement could be simplified quite a lot. This will replace all the code you posted:

Classification:

LOAD

sys_created_on as Classification_created_on,

sys_id as Classification_key,

u_name as Classification_name,

u_service_type as Classification_S_type,

u_type as Classification_type,

u_classification_0,

u_classification_1,

u_classification_2,

u_classification_3,

u_classification_4,

u_classification_5,

u_classification_6,

u_classification_7,

u_classification_8,

u_classification_9d;

SQL SELECT *

FROM ODS_ITSM.dbo.ITSM_Class_u_classification;

Re: Unknown Statement

bharatkishore — Wed, 27 May 2015 05:46:24 GMT

Thanks Jagan...I just forget...