Sintax Error Issue.

[jgarciaf106]

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.

[sunny_talwar]

What is the script?

[MK9885]

Can you paste full script?

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

[Clever_Anjos]

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

[jgarciaf106]

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

[maxgro · Accepted solution]

I think this line

ES_Worker's_Manager,

[jgarciaf106]

Thanks you nailed it.