topic Re: Consolidate data into qvd. in QlikView

Consolidate data into qvd.

jgarciaf106 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Consolidate data into qvd.

awhitfield — Thu, 26 Apr 2018 15:08:48 GMT

Hi Andres,

this article is pretty useful

Regards

Andy

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

Re: Consolidate data into qvd.

ychaitanya — Thu, 26 Apr 2018 15:17:26 GMT

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