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
