Update only new Data

[#1]

Hi

I have a database in ms-access and in it, almost 2 million records exists.

each day,I added 2000 to 2500 records new in my database

but when I Reload database, qlikview loading all 2 million records from A to Z. and it's time consuming

my question is:

could I use a way to add only new records to my Qlik Files?

best wishes

[jagan]

Hi,

You need to implement incremental loading, check below links

Script for Incremental Loading of Multiple QVDs from a List of Table Names

Incremental Load

Incremental Load @ Qlikview

Regards,

Jagan.

[#3]

Hi,

Use this code and this is only for insert only-

MAX:

LOAD

     DATIME

FROM  [table.qvd](qvd);

Res:

Load DATIME as ModDate

Resident MAX order by DATIME Desc;

Let MaxTimeStamp=Peek('ModDate',0);

Let MaxTIMESTAMP=Timestamp($(#MaxTimeStamp),'YYYY-MM-DD-hh.mm.ss.ffffff');

Drop Table Res,MAX;

QV:

SQL SELECT *

           FROM table

WHERE DATIME >= '$(MaxTIMESTAMP)';

CONCATENATE

LOAD      

           *

           FROM table(qvd);

store QV into table.qvd(qvd);

[#4]

Hi,

Attaching 1 more link for Incremental Load

http://www.resultdata.com/three-types-of-qlikview-incremental-loads/

Regards,

Joshmi

[mukesh24]

Hi,

why u r not creating QVD of table & use Incremental Logic on that transaction Table & then use in u r these QVD in u r scripting.

Regards,

Mukesh

[#6]

thanks everybody

could anyone help me and explain me how can I could use your helpful strings?

I attached a sample file in .rar format

and each files in separate.

I want to know:

1- how can create QVD file?

2-how can load data from my ms-access file?

3-how link between my qvw and qvd?

thank you in advance for helping me.

best wishes

[jagan]

Hi,

Did you gone through the links?  You will get answers for all your questions in those links.

Regards,

Jagan.