My QVW suddenly inline load script for Rate need to change from 1 to 6 ?

paulyeo11 — Mon, 04 May 2020 12:22:43 GMT

Hi All

I have below QVW , which work fine for last 9 year , last 2 day i try to convert the inline load script to load excel file , suddenly i need to change 1 to 6 in order to get the correct result :-

// 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
];

May i know why ?

Paul

topic My QVW suddenly inline load script for Rate need to change from 1 to 6 ? in QlikView

My QVW suddenly inline load script for Rate need to change from 1 to 6 ?