topic Partial load to load newly updated data to the existing data in the qlik application layer in App Development

Partial load to load newly updated data to the existing data in the qlik application layer

deep2021 — Sun, 04 Sep 2022 04:03:34 GMT

Hi,

My application is consuming a long time to reload the data. Is the partial load using the replace will help me out to append the newly updated data to the existing tables in the final application?

Please suggest.

Thanks

Re: Partial load to load newly updated data to the existing data in the qlik application layer

rubenmarin — Sun, 04 Sep 2022 16:12:27 GMT

Hi, yes, the partial load can help. But usually it's better to optimize the loads using qvds to do incremental loads and optimized loads.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-files-incremental-load.htm

https://community.qlik.com/t5/QlikView-Documents/Best-Practices-for-Data-Modelling/ta-p/1477748

Re: Partial load to load newly updated data to the existing data in the qlik application layer

deep2021 — Mon, 05 Sep 2022 16:00:28 GMT

Hi,

Replace can replace the existing table with the new one.
Add can simply append the table.
I have am getting the data in the form of excel.
The file having the same name. Rather than using full load we just want to append the data.

In this case rather than replace, add load will be useful.
Please correct me if I am wrong.

Thanks

Re: Partial load to load newly updated data to the existing data in the qlik application layer

rubenmarin — Mon, 05 Sep 2022 16:40:57 GMT

Hi, yes, it would be an Add.

Re: Partial load to load newly updated data to the existing data in the qlik application layer

deep2021 — Mon, 05 Sep 2022 18:38:54 GMT

Hi,

The application layer consumes a long time to load the data. We can apply the add load to the application layer too.

Please correct me if I am wrong.

Thanks

Re: Partial load to load newly updated data to the existing data in the qlik application layer

rubenmarin — Tue, 06 Sep 2022 06:07:44 GMT

Hi, yes, it can be applied.

Also the option to use qvds with incremental loads can be applied, but right now it will be easier to go with the partial load.