Discussion Board for collaboration related to QlikView App Development.
How to modfiy the below load script , BY adding SOURCE = COY2 , RATE =1 Regardless any date ?
sales:LOADDate#(date_inv, 'D/M/YYYY') AS date,Amount,company,SOURCE,ODSEINLINE [date_inv, Amount,company,ODSE,SOURCE1/1/2020, 1,JCS,AP,COY11/2/2020, 2,JCS,AP,COY1];noconcatenateSales_:Load date,Amount,company,SOURCE,ODSE,year(date) as [year],Day(date) as [Day],num(month(date)) as [month],Date(Monthstart(date), 'MMM-YYYY') as YearMonth,Date(Monthstart(date), 'MMM-YYYY') as MonthYearResident sales;
Drop table sales;
LOADRATE,Date#(date, 'D/M/YYYY') AS date,SOURCE
1/1/2020, 1,COY11/2/2020, 2,COY1];
The reason I need to add the SOURCE for RATE is because now my QV is not able to handle monthly exchange rate. Hope some one can advise me on my post above.
Can u try this?
Date#(date_inv, 'D/M/YYYY') AS date,
'COY2' As SOURCE,
1 As RATE