topic After convert inline load to load by excel , Field on Rate not link to sales Table in QlikView

After convert inline load to load by excel , Field on Rate not link to sales Table

paulyeo11 — Sun, 03 May 2020 09:54:47 GMT

Hi All

I have below load script , work fine :-

// Section (A)load change rate table

LOAD * INLINE [
SOURCE,Currency,Rate
TPG,RM,2.4
TDT,THAI,25
TDS,SG,1
ADL,SG,1
];

// Section (B) Load sales data 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, 1,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDS
14/2/2020, 2,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TPG
14/2/2020, 2,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
14/2/2020, 2,4,1235 ,YASKAWA,JCS,AP_SBU,AP,ADL
];

When i replace Section (A) load script with excel table below :-

Directory;
LOAD SOURCE,
Currency,
Rate,
Rate_,
date_t
FROM
Map_Rate.xlsx
(ooxml, embedded labels, table is Sheet1);

The Currency and Rate field from Excel table cannot link with sales Table.
Hope you can advise me where go wrong ?

Paul

Re: After convert inline load to load by excel , Field on Rate not link to sales Table

paulyeo11 — Sun, 03 May 2020 10:08:09 GMT

Hi All

use inline load , it will display Rate and currency. see below table :-

Below table when i load Excel table . Rate and Currency not display :-

Paul

Re: After convert inline load to load by excel , Field on Rate not link to sales Table

paulyeo11 — Sun, 03 May 2020 11:42:58 GMT

Hi All

i just found out it is due to SOURCE field value in excel and in line load are different. now work fine.

Paul