LOAD
PROJ_ID,
// PROJ_SHORT_NAME,
// DESCRIPTION,
TASK_CODE ,
//TASK_NAME,
RSRC_NAME,
RSRC_SHORT_NAME,
STARTDATE,
Date(STARTDATE) as Sdate,
WeekEnd(STARTDATE) as WeekEndDate,
ENDDATE,
ACTUALUNITS,
PARENT_RSRC_NAME
// TASK_ID
FROM [lib://Qvdsource/p6_actuals_RSRC_SPREAD.qvd]
(qvd);
Concatenate
LOAD
PROJ_ID,
//PROJ_SHORT_NAME,
//DESCRIPTION,
TASK_CODE,
//TASK_NAME,
RSRC_NAME,
RSRC_SHORT_NAME,
STARTDATE,
Date(STARTDATE) as Sdate,
WeekEnd(STARTDATE) as WeekEndDate,
ENDDATE,
REMAININGUNITS
FROM [lib://Qvdsource/p6_forecast_rsrc_spread.qvd]
(qvd);
concatenate
LOAD
PROJ_ID,
//PROJ_SHORT_NAME,
//DESCRIPTION,
TASK_CODE ,
//TASK_NAME,
RSRC_NAME,
RSRC_SHORT_NAME,
STARTDATE,
Date(STARTDATE) as Sdate,
WeekEnd(STARTDATE) as WeekEndDate,
ENDDATE,
PLANNEDUNITS
FROM [lib://Qvdsource/p6_planned_RSRC_SPREAD.qvd]
(qvd);
LOAD
PROJ_ID,
WBS_PROJ_ID,
PM_PROJ_ID,
PROJECT_NUMBER,
PLAN_START_DATE,
PLAN_END_DATE,
PRIM_PROJ_DESCRIPTION,
CONST_MANAGER_CODE,
CONST_MANAGER_NAME,
FACILITY_CODE,
FACILITY_NAME,
PROJECT_TYPE_CODE,
PROJECT_TYPE_NAME,
ORGANISATION_CODE,
ORGANISATION_NAME,
PROJ_MANAGER_CODE,
PROJ_MANAGER_NAME,
YARD_MANAGER_CODE,
YARD_MANAGER_NAME,
HR_MANAGER_CODE,
HR_MANAGER_NAME,
BUSINESS_UNIT_CODE,
BUSINESS_UNIT_NAME,
PROJECT_STATUS_CODE,
PROJECT_STATUS_NAME
FROM [lib://Qvdsource/P6_PROJECT_DETAILS_V.qvd]
(qvd) ;
LOAD
TASK_ID,
// PROJ_ID,
PROJ_SHORT_NAME,
PROJECT_DESCRIPTION,
TASK_CODE,
TASK_NAME,
TARGET_START_DATE,
TARGET_END_DATE,
PHYS_COMPLETE_PCT,
PROD_SUPERVISOR_CODE,
PROD_SUPERVISOR_NAME,
DISCIPLINE_CODE,
DISCIPLINE_ID,
DISCIPLINE_NAME,
// FACILITY_CODE,
//FACILITY_NAME,
LOCATION_CODE,
COST_CODE,
BASE_START_DATE,
BASE_END_DATE
FROM [lib://Qvdsource/p6_Task_Details_V.qvd]
(qvd);
dis is my script
