Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Update only new Data

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

6 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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);

Not applicable
Author

Hi,

Attaching 1 more link for Incremental Load

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

Regards,

Joshmi

mukesh24
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.