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

[deep2021]

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

[rubenmarin]

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-in...

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

[deep2021]

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

[rubenmarin]

Hi, yes, it would be an Add.

[deep2021]

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

[rubenmarin]

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.