topic Re: Sintax Error Issue. in QlikView

Sintax Error Issue.

jgarciaf106 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to load some tables via script (Generated by QlikView), but I am getting an error message" in two tables:

If I load the table alone removing the "; It loads, but if I load them together I won't load.

Any Thoughts?

Thanks In advanced.

Re: Sintax Error Issue.

sunny_talwar — Mon, 23 Oct 2017 18:37:13 GMT

What is the script?

Re: Sintax Error Issue.

MK9885 — Mon, 23 Oct 2017 18:38:20 GMT

Can you paste full script?

; <<<<< usually used to end the table load.

Re: Sintax Error Issue.

Clever_Anjos — Mon, 23 Oct 2017 19:01:04 GMT

probably you have a "," after the last column of your load

Re: Sintax Error Issue.

jgarciaf106 — Mon, 23 Oct 2017 19:43:02 GMT

Exit_Survey:

LOAD CLUSTER & '_' & COUNTRY & '_' & LOCATION & '_' & BUSINESS_UNIT & '_' & MONTH as ExitSurvey_Key,

ES_Employee_ID,

ES_Preferred_Name,

ES_Company,

ES_Business_Title,

COUNTRY,

CLUSTER,

ES_REGION,

LOCATION,

BUSINESS_UNIT,

ES_Division_Name,

"[ES_Cost_Center_-_ID]",

"[ES_Cost_Center_-_Name]",

ES_Pay_Group,

ES_Supervisory_Organization,

ES_Worker's_Manager,

ES_Manager_ID,

[ES_Employee/CW_Type],

ES_Compensation_Grade,

ES_Hire_Date,

ES_Time_in_Position,

ES_Primary_Termination_Reason,

ES_Termination_Reason,

"[ES_Termination_Reason_-_Local]",

ES_Termination_Date,

MONTH,

ES_Date_and_Time_Completed,

ES_Termination_Process_Status,

ES_Last_Day_of_Work,

"[ES_Resignation_Date]",

"[ES_What_is_your_primary_reason_for_leaving?]",

"[ES_Did_you_have_regular_and_effective_PDP_discussions_with__your_Manager_with_clear_development_objectives?]",

"[ES_Were_you_satisfied_with_the_formal_training_offered?]",

"[ES_Were_there_learning_opportunities_available_to_support_your_professional_development?]",

"[ES_Do_you_feel_the_Company_Expectations_and_Company_Values_are_evident_in_the_way_people_work?]",

"[ES_Please_rate_your_overall_job_satisfaction_at_Company.]",

"[ES_Would_you_recommend_Company_as_an_employer_for_others_to_consider?]",

"[ES_Would_you_consider_returning_to_Company_in_the_future?]",

"[ES_Would_you_like_HR_to_follow_up_with_you_for_further_discussion?]",

"[ES_Completion_Status]"

FROM

(ooxml, embedded labels, table is Exit_Survey);

Re: Sintax Error Issue.

maxgro — Mon, 23 Oct 2017 19:48:50 GMT

I think this line

ES_Worker's_Manager,

Re: Sintax Error Issue.

jgarciaf106 — Mon, 23 Oct 2017 19:54:56 GMT

Thanks you nailed it.