I am trying to implement Incremental load with the followwing script but after load it shows zero lines fetched .
I have attahced the excel sheet from which I fetched the data then conevrted to qvd format .
I am confused like where I am going wrong can someoen please help me with this ? below is the code for incremental load
IncrementalLayer: LOAD ID, Status, date FROM inc_layer1.qvd (qvd);
Last_Updated_Date: LOAD Date(max(date),'MM/DD/YYYY') as maxdate Resident IncrementalLayer; LET vLast_Updated_Date = Peek('maxdate',0,'Last_Updated_Date'); DROP Table IncrementalLayer;
SourceDate: LOAD ID, Status, date FROM [Incremental test.xlsx] (ooxml, embedded labels, table is Sheet1) where date > Date('$(vLast_Updated_Date)','MM/DD/YYYY'); store * from SourceDate into inc_layer1.qvd(qvd);