Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am new to qlikview , i am practicing incremental load but after putting where condition i am getting a error field not found.
Can any one help please?
Pfa the files attached.
Regards
Manu
Don't see any Where clause in your script.
please see the new qvw file
Try this
change the paths accordingly with your excel sheet and QVD paths.
Sales:
LOAD Customer,
[Sales Order ID],
Date#(ShipDate,'DD-MM-YYYY') AS ShipDate,
Product,
Sales, Quantity
FROM [..\Desktop\RoughForum_Files\Sales Orders .xls]
(biff, embedded labels, table is [Sales Orders$]);
Temp:
LOAD MAX( Num#(ShipDate)) as MaxDate
Resident Sales;
let vMaxDate = Peek('MaxDate',0,Temp);
TRACE >>> $(vMaxDate);
Store Sales into C:\Users\VNAGARAJ\Desktop\RoughForum_Files\Sales.Qvd(qvd);
DROP Table Sales;
Sales2:
LOAD Customer, [Sales Order ID], ShipDate, Product, Sales, Quantity
FROM [..\Desktop\RoughForum_Files\Sales Orders .xls] (biff, embedded labels, table is [Sales Orders$])
where [ShipDate]>> $(vMaxDate);
Concatenate
LOAD Customer, [Sales Order ID], ShipDate, Product, Sales, Quantity
FROM C:\Users\VNAGARAJ\Desktop\RoughForum_Files\Sales.Qvd (qvd);