Hi I am trying to create a Link table and I am having some issues,
The Fact tables run correctly, but when running the Link Tables script (Highlighted in Red Below) I am getting the error:
SQL##f - SqlState: 37000, ErrorCode: 4294964196, ErrorMsg: [Microsoft][Controlador ODBC Excel] Error de sintaxis (falta operador) en la expresión de consulta '`MONTH`
Resident Exit_Survey'.
LinkTable:
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident Exit_Survey
Any Suggestion?
Here is the script i am trying to run,
// Fact Tables
//-------- Start Multiple Select Statements ------
Exit_Survey:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER`& '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`ES_Business_Title`,
`ES_Company`,
`ES_Compensation_Grade`,
`ES_Completion_Status`,
`ES_Cost_Center_-_ID`,
`ES_Cost_Center_-_Name`,
`ES_Date_and_Time_Completed`,
`ES_Did_you_have_regular_and_effective_PDP_discussions_with__your`,
`ES_Division_Name`,
`ES_Do_you_feel_the_GSK_Expectations_and_GSK_Values_are_evident_i`,
`ES_Employee/CW_Type`,
`ES_Employee_ID`,
`ES_Hire_Date`,
`ES_Last_Day_of_Work`,
`ES_Manager_ID`,
`ES_Pay_Group`,
`ES_Please_rate_your_overall_job_satisfaction_at_GSK#`,
`ES_Preferred_Name`,
`ES_Primary_Termination_Reason`,
`ES_REGION`,
`ES_Resignation_Date`,
`ES_Supervisory_Organization`,
`ES_Termination_Date`,
`ES_Termination_Process_Status`,
`ES_Termination_Reason`,
`ES_Termination_Reason_-_Local`,
`ES_Time_in_Position`,
`ES_Were_there_learning_opportunities_available_to_support_your_p`,
`ES_Were_you_satisfied_with_the_formal_training_offered?`,
`ES_What_is_your_primary_reason_for_leaving_GSK?`,
`ES_Worker's_Manager`,
`ES_Would_you_consider_returning_to_GSK_in_the_future?`,
`ES_Would_you_like_HR_to_follow_up_with_you_for_further_discussio`,
`ES_Would_you_recommend_GSK_as_an_employer_for_others_to_consider`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Exit_Survey$`;
Head_Count:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`HC_Age`,
`HC_Age_Category`,
`HC_Compensation_Grade`,
`HC_Division_Name`,
`HC_Employee\CW_Type`,
`HC_Employee_ID`,
`HC_Full_Legal_Name`,
`HC_Gender`,
`HC_Grade_category`,
`HC_Manager's_Employee_ID`,
`HC_Original_Hire_Date`,
`HC_RATE_1_or_2`,
`HC_Rating_-_Current`,
`HC_Region`,
`HC_Short_Service`,
`HC_Ternure`,
`HC_Worker's_Manager`,
`HC_Worker_Type`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Head_Count$`;
PDP:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`PDP_DEV_in_place`,
`PDP_Division`,
`PDP_Employee_ID`,
`PDP_HR`,
`PDP_Is_International_Assignee`,
`PDP_Manager`,
`PDP_More_tan_1_performance_objective?`,
`PDP_More_than_1_Development_Items?`,
`PDP_Name`,
`PDP_PO_in_place`,
`PDP_Region`,
`PDP_Worker_Type`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`PDP$`;
Promotion:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`Promo_Effective_Date`,
`Promo_Employee_ID`,
`Promo_Employee_Type`,
`Promo_Region`,
`Promo_Worker`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Promotion$`;
Recognition:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`Reco_Compensation_Element`,
`Reco_Employee`,
`Reco_Employee_ID`,
`Reco_Region`,
`Reco_Scheduled_Payment_Date`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Recognition$`;
Remedy:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `MONTH` As [%Key field],
`Reme_ARRIVAL_TIME`,
`Reme_CATEGORY`,
`Reme_CREATE_TIME`,
`Reme_HOURS_TO_RESOLVE`,
`Reme_KEYWORD`,
`Reme_PRDT`,
`Reme_Region`,
`Reme_RESOLVING_AGENCY`,
`Reme_Resolving_level`,
`Reme_SOURCE`,
`Reme_STATUS`,
`Reme_SUMMARY`,
`Reme_TICKET_ID`,
`Reme_TICKET_REACTIVATED`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Remedy$`;
Talent:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `QUARTER` As [%Key field],
`Tal_2015_Performance_Rating`,
`Tal_9_Box_`,
`Tal_9_Box_Placement`,
`Tal_9_box_talent`,
`Tal_Box`,
`Tal_Current_Performance_Rating`,
`Tal_Division`,
`Tal_Employee_ID`,
`Tal_HR`,
`Tal_In_Key_Role`,
`Tal_Organization`,
`Tal_Position`,
`Tal_Region`,
`Tal_Region1`,
`Tal_Succession`,
`Tal_Worker`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Talent$`;
Talent_Profile:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `QUARTER` As [%Key field],
`TalPro_Employee_ID`,
`TalPro_Region`,
`TalPro_Talent_Profile_Complete`,
`TalPro_Worker`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Talent_Profile$`;
Turn_Over:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`TO_Box_4,7,8,9`,
`TO_Box_Placement`,
`TO_Current_Employee_Rating`,
`TO_Employee/CW_Type`,
`TO_Employee_ID`,
`TO_First_Name`,
`TO_Full_Name`,
`TO_Hire_Date`,
`TO_Last_Name`,
`TO_Manager_ID`,
`TO_RATE_1_or_2`,
`TO_Region`,
`TO_Short_service`,
`TO_Tenure`,
`TO_Termination_Date`,
`TO_Termination_Reason`,
`TO_Termination_Reason1`,
`TO_Voluntary/Involuntary_Terminations`,
`TO_Worker's_Manager`,
`TO_Worker_Type`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`Turn_Over$`;
VOC:
SQL SELECT `BUSINESS UNIT` & '|' & `CLUSTER` & '|' & `COUNTRY` & '|' & `LOCATION` & '|' & `MONTH` As [%Key field],
`VC_Business_Area`,
`VC_Category`,
`VC_Completed_Date`,
`VC_Exec_Flag`,
`VC_Feedback`,
`VC_Feedback_ID`,
`VC_Overall_Rating`,
`VC_RA`,
`VC_Reference`,
`VC_Region`,
`VC_Request_Contact`,
`VC_Submitter_Name`,
`VC_Ticket_Assignee`,
`VC_Type`,
`VC_VOC`
FROM `C:\Users\FamGa\Desktop\QV_DataBase.xlsx`.`VOC$`;
//-------- End Multiple Select Statements ------
// LinkTables
LinkTable:
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident Exit_Survey;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident Head_Count;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident PDP;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident Promotion;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident Recognition;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`MONTH`
Resident Remedy;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`QUARTER`
Resident Talent;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`QUARTER`
Resident Talent_Profile;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident Turn_Over;
Concatenate(LinkTable)
SQL SELECT DISTINCT
[%Key field],
`BUSINESS UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident VOC;
