Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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

2 Replies
paulyeo11
Master
Master
Author

My QVW and Rate table

paulyeo11
Master
Master
Author

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