Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
In the Link table you are doing resident, So instead Select use Load. It should like attached
Open in notepad ++ for Qlikview.
I am getting this error:
Table not found error
Table 'LinkTable' not found
Concatenate(LinkTable)
LOAD
[%Key field],
`BUSINESS_UNIT`,
`CLUSTER`,
`COUNTRY`,
`LOCATION`,
`MONTH`
Resident PDP
Try to post the error message snap?
Try this way?
This errors comes up for each of the scripts in the link table
Please check new attachment above
Edit - Attached with some modification, Because SQL function throws an error 42000 Qlik connector for Routine scanning error when we write something like composite key with in the Package.
So, You can do preceding load further and let us know with attachment.