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