LINK_Table

poojashribanger — Thu, 19 Apr 2018 07:14:06 GMT

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;

topic LINK_Table in App Development