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

INCREMENTAL LOAD WITH OUT DATE FIELD :: REQUIRED WEEKLY REFRESH

Hi Everyone,

We Were planning to do an Incremental load which is going to perform every week,  but we have only Month and Year fields were available.

Source Table from AZURE:

Material,

Plant,

Sales,

Quantty,

Month,

Year

From sql.db.

 

Could you please let us know how to write incremental script for weekly refresh.

Thanks,

Krish

1 Reply
Or
MVP
MVP

There is no way to write a true incremental update based on weeks if your data does not include dates or weeks. You could instead write an update that always reads the current and previous months, replacing any previous data for these months. That would be the minimum load period for always getting the previous week if you don't have date or week fields.