Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You need to implement incremental loading, check below links
Script for Incremental Loading of Multiple QVDs from a List of Table Names
Regards,
Jagan.
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);
Hi,
Attaching 1 more link for Incremental Load
http://www.resultdata.com/three-types-of-qlikview-incremental-loads/
Regards,
Joshmi
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
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
Hi,
Did you gone through the links? You will get answers for all your questions in those links.
Regards,
Jagan.