Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Insert only

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

View solution in original post

Not applicable
Author

Thanks Vimlesh

I really appreciate ur reply to me , i will implement this into my qlikview script and let you know

Thanks a lottttt