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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kmmqlick
Contributor III
Contributor III
‎2022-12-15 12:54 AM

Inline Load

Hi team, 

I am getting sales data every year, Example Shown in below table, every year last data updated in data base.

I am using 2 tier architecture , first one for Extraction and second one final Application.

How to write incremental load in this case

Product Year Month Sales
Pen 2019 DEC 100
Eraser 2019 DEC 420
Pencil 2019 DEC 580
Pen 2020 DEC 100
Eraser 2020 DEC 420
Pencil 2020 DEC 580
Pen 2021 DEC 100
Eraser 2021 DEC 420
Pencil 2021 DEC 580
Labels (1)
Labels
440 Views
0 Likes
0 Replies