topic Single Generator to create multiple QVDs in QlikView

Single Generator to create multiple QVDs

Wed, 15 Feb 2012 22:32:30 GMT

Hi All,

I have a generator that creates a single QVD with last five years of data and I have implimented incremental load in it.This generator loads everyday and it takes approx an hour.

Now objective is to reduce the load time.Plan is to create five different QVDs for each year and for the current year QVD only need to add incremental load.

Example:

DtKey	Name	Val
20080101	Jon	100
20081231	Jill	200
20090101	Jack	300
20090101	Jeff	400
20091231	Jean	500
20100101	Jenna	600
20101231	Jeanna	700
20110101	Jennifer	800
20111231	Jacob	900
20120101	Kelly	100
20120102	Mary	200
20120103	Matt	900

Need to have 2008.QVD,2009.QVD,2010.QVD,2011.QVD and 2012.QVD.Only for 2012.QVD have to implement incremental load.

Can anyone suggest how can I create five different QVDs from a single resident table and only implement incremenatl load for current year QVD.Thanks...

Single Generator to create multiple QVDs

kamalqlik — Thu, 16 Feb 2012 05:20:28 GMT

Ya Sure it can be done.You can just put the Condition in the script with the date filter so that different year data come in five QVD's and store them.

You can do something lyk this.

Load All fields

from QVD

Than use the year one by one as filter

and store thet QVD with it's year name one by one

regards

Kamal

Single Generator to create multiple QVDs

jagan — Thu, 16 Feb 2012 05:50:17 GMT

Hi,

I think splitting single QVD into 5 QVDs doesn't help in improving performance. Is your previous years data change?

If not load previous years into separate qvd for once and use that QVD without reloading everytime. You just load the current year data.

Instead of loading all past and present data just load only the present data.

Hope this helps you.

Regards,

Jagan.