Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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