Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All
I want to write inseet only incremental load to this below script .
what i should do
Record:
LOAD Company,
Native,
Classes,
Height,
Goinger,
Sets,
x,
y,
z,
[Invoice Date] as Date
FROM
[D:\Incremental Data-Record
(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
Dear,
Use this code and this is insert only(use date format according to your invoice date in database) and set in variable.
Max:
LOAD
[Invoice Date]
FROM E:\Qlikview\Data\RawQVD\Record.qvd(qvd);
Res:
Load [Invoice Date] as ModDate
Resident Max order by [Invoice Date] Desc;
Let MaxTimeStamp=Peek('ModDate',0);
Let MaxTIMESTAMP=Timestamp($(#MaxTimeStamp),'YYYY-MM-DD-hh.mm.ss.ffffff');
drop table Max,Res;
Record:
LOAD
*;
SQL SELECT *
FROM B005592P.TABLENAME
WHERE [Invoice Date] > '$(MaxTIMESTAMP)';
CONCATENATE
LOAD
*
FROM E:\Qlikview\Data\RawQVD\Record.qvd(qvd);
STORE Record into Record.qvd(qvd);
Regards
Vimlesh
Dear,
Use this code and this is insert only(use date format according to your invoice date in database) and set in variable.
Max:
LOAD
[Invoice Date]
FROM E:\Qlikview\Data\RawQVD\Record.qvd(qvd);
Res:
Load [Invoice Date] as ModDate
Resident Max order by [Invoice Date] Desc;
Let MaxTimeStamp=Peek('ModDate',0);
Let MaxTIMESTAMP=Timestamp($(#MaxTimeStamp),'YYYY-MM-DD-hh.mm.ss.ffffff');
drop table Max,Res;
Record:
LOAD
*;
SQL SELECT *
FROM B005592P.TABLENAME
WHERE [Invoice Date] > '$(MaxTIMESTAMP)';
CONCATENATE
LOAD
*
FROM E:\Qlikview\Data\RawQVD\Record.qvd(qvd);
STORE Record into Record.qvd(qvd);
Regards
Vimlesh
Thanks Vimlesh
I really appreciate ur reply to me , i will implement this into my qlikview script and let you know
Thanks a lottttt