Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

Daily data refresh tracking

Dear All,

 

I have multiple table but here I am considering only 2 of them for example.

1) customer

2) order

I want to display the daily refresh detail of these tables on my ETL app first sheet in table object as follows:

 

Table name    No.of records  Last modified date

Customer        2000                    12/25/2023

order                 5000                    12/24/2021

When I reload this app next day then it should display next day details as below :

 

Table name    No.of records  Last modified date

Customer        3000                    12/26/2023                       // no of records has been increased by 1000 and date also changed 

order                 5000                    12/24/2021

 

this is to track the detail about my all the ETL tables on daily basis to know if there is any records has added or deleted.

How can I achieve this.

 

 

Labels (1)
1 Solution

Accepted Solutions
MendyS
Partner - Creator III
Partner - Creator III

Hi @Mahamed_Qlik 
Its sound like you want to make a Incremental load?
 

View solution in original post

2 Replies
MendyS
Partner - Creator III
Partner - Creator III

Hi @Mahamed_Qlik 
Its sound like you want to make a Incremental load?
 

Mahamed_Qlik
Specialist
Specialist
Author

Yes. Incremental..How I can achive this