Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is the script?
Can you paste full script?
; <<<<< usually used to end the table load.
probably you have a "," after the last column of your load
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);
I think this line
ES_Worker's_Manager,
Thanks you nailed it.