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: 
Sra1bandi
Contributor III
Contributor III

How to fetch missing data by using incremental load?

Hi Team,

 

I have data which is updating on daily basis due to format issues of CSV file few data it's not fetched.

Now we identified the issue in CSV file and cleared it.

We are using incremental load to load data on daily basis we are using Max date field to load only new data now how to include missed data for old dates?

How to fetch missing data by using incremental load?

Regards,

Sra1.

 

 

Labels (1)
1 Reply
Keitaru
Creator II
Creator II

hmmm I'm looking for something similar to deal with missing data/Old Data from source to QVD when 

Have an idea of using not exists(date) and also if you are doing 1 day data load might want to have

 

 

Load * 

FROM Your.qvd
Where date <> Source_file_max(date) ;