topic Re: QVD New Monthly files in QlikView

QVD New Monthly files

Tue, 05 May 2015 11:35:50 GMT

We have a table which is updated on a monthly basis. On the initial load I need to create a qvd file for each month, for example the month field is FinMonth in this format 201501, 201502 etc.

Do I need to create files called Data201501.qvd, Data201502.qvd.

The source data is only updated once a month, but I do not want to recreate the previous months data files continuously, only once there is data for the new month I need to create a new qvd - as I said above this will only happen once per month, so normally early in May we will get values added for April. What is the best way to do this?

Re: QVD New Monthly files

buzzy996 — Tue, 05 May 2015 11:40:41 GMT

modify this logic accordingly ur needs.

Re: qvd separation?

Re: QVD New Monthly files

Tue, 05 May 2015 11:57:43 GMT

Don't think this is what I really want. I also need to understand auto

naming of files and not a load reload of qvd files. I juts need a first

load of all months from a source into monthly qvd files and thereafter a

check if new data is available, note not on a date modified field but on a

new set of data for an entire month

Re: QVD New Monthly files

peter_turner — Tue, 05 May 2015 13:23:58 GMT

Hello,

You need to have some way to tell when there is new data, and you can then code this logic into the script to make Incremental Loading, checkout the standard help inside the QlikView application on this topic, and some of the community posts on this subject.

Once you know how to identify the new data such as FinMonth>201502 you can do something roughly like this

Let NewDataFlag='201502';

//Set your condition to only load the new data

New_Table:

LOAD

Your_Fields

FROM

Your_Data_Source

WHERE

FinMonth>=$(NewDataFlag);

//Only load your new data

Store New_Table into New_QVD$(NewDataFlag).qvd (QVD);

Then set your NewDataFlag to be the last row of the loaded data ready for the next reload.