How to Create Link Tables?

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

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;

Re: How to Create Link Tables?

jgarciaf106 — Tue, 17 Oct 2017 01:41:54 GMT

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

topic Re: How to Create Link Tables? in QlikView

How to Create Link Tables?

Re: How to Create Link Tables?

Re: How to Create Link Tables?

Re: How to Create Link Tables?

Re: How to Create Link Tables?

Re: How to Create Link Tables?

Re: How to Create Link Tables?