Consolidate data into qvd.

[jgarciaf106]

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.

[awhitfield · Accepted solution]

Hi Andres,

this article is pretty useful

Regards

Andy

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

[ychaitanya]

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