topic Re: Insert only in QlikView

Insert only

Mon, 16 Mar 2015 07:18:02 GMT

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,

[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

Re: Insert only

Mon, 16 Mar 2015 07:24:42 GMT

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

Re: Insert only

Mon, 16 Mar 2015 07:37:41 GMT

Thanks Vimlesh

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

Thanks a lottttt