Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.