Loading only the modified data in to existing rows of the table using qlikview

[#1]

Hi All,

Imagine after loading data in to qlikview(desktop) if I did any modification in the database and wants to load only load only those data in to the same row where it was existing previously(Reloading only the modified data instead of loading all the data every time after doing any modification) . If it is possible let me know how qlikview will identify which row has been modified(How qlikview will get to know which row has been modified). Also imagine I don't have any columns which stores the modified date and time in any of my tables.

Can any share their experience on this.

Thanks and Regards,

Rikab

[#2]

Hello All,

Anybody having answer for this? Because each time when any rows are modified I want to load only the modified rows instead of loading all the rows which creating performance problem.

Thanks and Regards,

Rikab

[#3]

Hi Rikab,

Your Quetion:- Reloading only the modified data instead of loading all the data every time after doing any modification.

Ans:- For reloading only modified data, in the DB should be having a column called modified/created date. And as a daily basis when the data getting reloaded we sholud add a condition after the load script like example:

Load

Script

where modifieddate>=reloadeddate (last reloaded date of the application);

This will load only the data modified after last reload of the application. I hope this will solve your issue.

[Oleg_Troyansky]

All the possible features of Incremental Load are well described in the Help Article "Using QVD files for incremental load" (search for "Incremental Load").

I doubt, however, that you can do anything without the Timestamp of the data change.

[#5]

chenna1506 wrote:
Hi Rikab,
Your Quetion:- Reloading only the modified data instead of loading all the data every time after doing any modification.
Ans:- For reloading only modified data, in the DB should be having a column called modified/created date. And as a daily basis when the data getting reloaded we sholud add a condition after the load script like example:
Load Script where modifieddate>=reloadeddate (last reloaded date of the application);
This will load only the data modified after last reload of the application. I hope this will solve your issue. <div></div>

Yes, Chenna I had thought for this thing only and that i want mentioned in my post that "Also imagine I don't have any columns which stores the modified date and time in any of my tables.". But just wanted to know is there is any other method do so other than the adding modified date column in our table.

If it can be done let me know in what basis qlikview finds which rows are modified.

Thanks for your effort,

Regards,

Rikab