key table problem

adiarnon — Tue, 05 May 2015 06:55:13 GMT

HI,

i created a key table but it not reacting like i want.

for examlpe-

i created a table with a field grom the masterlink table and a field from the project table.

if the field from the project table is project_id - its workink fine,

if the field from the project table is project_name it not working.

this is my key table-

please look if im doing it right-

LOAD Distinct
     Task_Key,
     Task_ID,
     Proj_Task_ID,
     Project_ID,
     Task_ERP_CC,
     Task_ERP_PCA,
     Task_ERP_Project
resident TASKS;

Outer Join

LOAD Distinct
Project_Key,
Project_ID
resident PROJECT;

Outer Join

LOAD Distinct
Assignment_Key,
Assignment_ID,
Task_ID,
Proj_Task_ID,
Project_ID,
Resource_ID,
Date
resident ASSIGNMENTS_BY_DAY;

Outer Join

LOAD Distinct
MASTERLINK_Key,
    Task_ID,
    Proj_Task_ID,
    Project_ID
resident MASTERLINK;

Outer Join

LOAD Distinct
Resource_Key,
Resource_ID
resident RESOURCES;
Store Key_Table Into $(PathDoc)Key_Table.qvd (qvd);
Drop Table Key_Table;

Key_Table:
LOAD Distinct
Project_Key,
Task_Key,
Resource_Key,
Assignment_Key,
MASTERLINK_Key,
Project_ID ,
Task_ID,
Proj_Task_ID,
Task_ERP_CC,
Task_ERP_PCA,
Task_ERP_Project,
Resource_ID ,
Assignment_ID,
Date
FROM $(PathDoc)Key_Table.qvd (qvd);
Store Key_Table Into $(PATH)Fact_KeyTable.qvd (qvd);

DROP Fields Project_ID From PROJECT;
DROP Fields Task_ID,Proj_Task_ID,Project_ID,Task_ERP_CC, Task_ERP_PCA,Task_ERP_Project From TASKS;
DROP Fields Resource_ID From RESOURCES;
DROP Fields Assignment_ID,Task_ID,Proj_Task_ID,Project_ID,Resource_ID,Date From ASSIGNMENTS_BY_DAY;
DROP Fields Task_ID,Proj_Task_ID,Project_ID from MASTERLINK;

Re: key table problem

Gysbert_Wassenaar — Tue, 05 May 2015 08:55:07 GMT

LOAD Distinct
      ...
    Project_ID,
    ....
resident TASKS;

Outer Join

LOAD Distinct
Project_Key,
Project_ID
resident PROJECT;

The TASKS table contains the field Project_ID. It does not contain a field Project_Name. If you use Project_Name from PROJECT then you get a cartesian product.

topic key table problem in QlikView

key table problem

Re: key table problem