How to make my exchange rate table date link with my master calendar ?

[paulyeo11]

Hi All

My below script no error :-

// Section 1 Load exchange table
RATE:
LOAD SOURCE,
Currency,
Rate,
Date(date_t, 'D/M/YYYY') as date,
Date(date_t, 'D/M/YYYY') as date_RATE,
Rate_,
date_t
FROM
[Map_Rate.xlsx]
(ooxml, embedded labels, table is Sheet);

// Section 2 Load sales table
sales:
LOAD
Date#(date_inv, 'D/M/YYYY') AS date,
LineSalesAmount,
profit_amt,
inv_no,
BRAND,
company,
SOURCE,
sbu,
ODSE

INLINE [date_inv, LineSalesAmount,profit_amt,inv_no,BRAND,company,sbu,ODSE,SOURCE
14/1/2020, 30,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
14/2/2020, 10,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
];


My issue is Rate Table date field not able to link to master calendar table.

Hope some one can advise me.

Paul

[paulyeo11]

My QVW and Rate table

[paulyeo11]

Hi All

I just try to modify the sales table date to below :-

INLINE [date_inv, LineSalesAmount,profit_amt,inv_no,BRAND,company,sbu,ODSE,SOURCE
1/1/2020, 30,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
1/2/2020, 10,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
];

Which is same as my Exchange table date , then it work fine.

But in actual fact the date cannot be same.

Paul Yeo