Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
imrasyed
Partner - Creator II
Partner - Creator II

Multiple loads per day

Hi Experts,

I have historical data from DB and its taking lot of time to load it in Qliksense.

To resolve that issue I am using incremental load.

The issue i am facing is i have multiple loads per day.

And when i am getting max date and concatenating with the existing qvd i will be getting multiple loads.

But instead i need only the latest loaded data per day.

Example:

loaded_dt:

9/10/2022 7:10

9/10/2022 18:30

---

---

9/19/2022 7:10

9/19/2022 18:30

What i need is 

9/10/2022 18:30

9/11/2022 18:30

---

---

9/19/2022 18:30

Is it possible to acheive this using incremental load?

Appreciate your help.

Labels (1)
20 Replies
imrasyed
Partner - Creator II
Partner - Creator II
Author

Hi @RafaelBarrios 

For now we are going with group by logic and planning to upgrade Qliksense to latest version and hence use partial load feature.

 

Thanks a lot for all the help.