topic Update only new Data in QlikView

Update only new Data

Tue, 24 Feb 2015 05:53:45 GMT

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

Re: Update only new Data

jagan — Tue, 24 Feb 2015 06:01:25 GMT

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.

Re: Update only new Data

Tue, 24 Feb 2015 06:07:47 GMT

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

Re: Update only new Data

Tue, 24 Feb 2015 06:10:16 GMT

Hi,

Attaching 1 more link for Incremental Load

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

Regards,

Joshmi

Re: Update only new Data

mukesh24 — Tue, 24 Feb 2015 06:30:48 GMT

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

Re: Update only new Data

Tue, 24 Feb 2015 06:59:04 GMT

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

Re: Update only new Data

jagan — Tue, 24 Feb 2015 07:04:29 GMT

Hi,

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

Regards,

Jagan.