Incremental issue

[manu1512]

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

[m_woolf]

Don't see any Where clause in your script.

[manu1512]

please see the new qvw file

[vishsaggi]

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);