I have created a link Table and i am getting values.
but the values which i am getting is reduced by 3 times the original value.
why is it so?
This is my Script
LINK_TABLE:
load distinct *,
upper(date(date))&'-'&upper(IBU) as [%map_Key];
load distinct
[%Key],
upper([Finance Date]) as date,
upper(CDU) as IBU,
upper(Finance_cg) as [Customer group]
Resident VW_FACT_CDG_PNL;
Concatenate(LINK_TABLE)
load distinct *,
upper(date(date))&'-'&upper(IBU) as [%map_Key];
load distinct
[%Key1],
upper(date(TRANSACTION_EFFECTIVE_DT)) as date,
upper(EMPLOYEE_IBU_ID) as IBU,
upper(base_cg) as [Customer group]
Resident TM_RW_BASEDATAVIEW_TBL;
Concatenate(LINK_TABLE)
load distinct *,
upper(date(date))&'-'&upper(IBU) as [%map_Key];
load distinct
[%Key2],
upper(date(MNTH_DT)) as date,
upper(IBU_ID) as IBU,
upper(CUSTOMER_GROUP_NAME) as [Customer group]
Resident Resource_Utilization;
drop Fields
[Finance Date],
CDU,
Finance_cg from VW_FACT_CDG_PNL;
drop Fields
TRANSACTION_EFFECTIVE_DT,
EMPLOYEE_IBU_ID,
base_cg
from TM_RW_BASEDATAVIEW_TBL;
drop Fields
MNTH_DT,
IBU_ID,
CUSTOMER_GROUP_NAME from Resource_Utilization;