Selective QVD load

[#1]

Hi,

I have a problem where data is stored into multiple qvd files (broken down in either daily/montly/yearly).

I wish to have a model where the qvd file can be selected and then only loaded into memory for further investigation from a model.

How can I do this?

[Gabriel]

Hi,

I don't think I completely understand your requirement but I think the idea below might start off suggestions.

//Define variables to use later in the script

LET vQVDPath				= '..\..\QVD Files Folder\';
LET vQVDFileToLoad		=0;

IF vQVDFileToLoad	= 0		THEN
LET vQVDFileToLoad	=    'Daily';

ELSEIF  vQVDFileToLoad = 1	THEN
LET vQVDFileToLoad	=    'Monthly';

ELSEIF  vQVDFileToLoad = 2	THEN
LET vQVDFileToLoad	=    'Yearly';

ENDIF

//Here is the table to Load into memory

Fact:

LOAD

Field1

, Field2

, Field3

, Field4

FROM [$(vQVDPath)$(vQVDFileToLoad).qvd](qvd);

//Clean Up variable

LET vQVDFileToLoad =;

[#3]

Hi,

The idea is to list the QVD files available in a model and then from the list select (like a date range) the dates to load.  After the selection the in the model the QVD's selected will be loaded. i.e the folder contains:

QVD201510.qvd

QVD201509.qvd

QVD201508.qvd

QVD201507.qvd

QVD201506.qvd

...

So in the list I want to select month 8 and 9 and click load.  This then will load the appropriate QVD's.

[Gabriel]

Hi,

So listing of the QVD files to load is it done in the UI or script?

[#5]

The listing has not been done yet but I assume it will be done in a script and displayed in the UI. Unless there is another way of doing it.