Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
jgarciaf106
Creator
Creator

Consolidate data into qvd.

Hi Experts, 



I have the following question and I need a bit of advise.


I pull data from an Oracle DB once a Month, i want to consolidate the data into a qvd but with the following requirement:


Keep the data from the previous month and not replace it


Example:


Run on january will contain the run date as jan 31.

Next time I run i want add february information consolidated with january, so At the end of the year I could view what the information was between months.


Is this possible?



Thanks in advanced.

1 Solution

Accepted Solutions
awhitfield
Partner - Champion
Partner - Champion

2 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Andres,

this article is pretty useful

Regards

Andy

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

ychaitanya
Creator III
Creator III

Yes This is possible with Incremental Load Concept .

or creating the table dynamically every month and concatenating to the Original table also will do .

Thanks

Cy