Im having a question regarding the incremental loa... - Qlik Community

SK28 · ‎2025-03-16

Hi

I'm having a QVD & the database, where I need to Insert the new rows, update it and delete some records.

We are having lots of data, everytime when we are trying to update,insert and delete it is taking too much of run time.

If we are running the QVD daily twice morning and in the evening,

Everything it has to go through each and every record, to check whether it is updated or needs to be deleted or its needs to be Inserted,

Is there a way to handle this scenario, because everytime it has to go through the whole process and it's taking too much of time,

Can you please help me with this how to handle needs some suggestions & how to handle, these kind of scenarios

ramchalla · ‎2025-03-16

Hi,

Please follow the below links.

paulcalvet · ‎2025-03-17

Hello,

You can try the merge function, it's exactly your use case :

Regards,

Im having a question regarding the incremental load (update,delete,insert)