Discussion Board for collaboration related to QlikView App Development.
I want to write inseet only incremental load to this below script .
what i should do
[Invoice Date] as Date
(biff, embedded labels, table is Sheet1$)
I gone throught many documnets but could not understand it
I hope some one can help me .
Thanks and regards
Use this code and this is insert only(use date format according to your invoice date in database) and set in variable.
Load [Invoice Date] as ModDate
Resident Max order by [Invoice Date] Desc;
drop table Max,Res;
SQL SELECT *
WHERE [Invoice Date] > '$(MaxTIMESTAMP)';
STORE Record into Record.qvd(qvd);
View solution in original post
I really appreciate ur reply to me , i will implement this into my qlikview script and let you know
Thanks a lottttt