topic Re: One QlikView data file = multiple QVDs in QlikView

One QlikView data file = multiple QVDs

alexis — Wed, 27 Aug 2014 18:32:35 GMT

Hi all,

In the attached QVW you will see just a single table (XX)

One of the fields in that table is called QVDFilename which I have constructed from other fields and it signifies (as the name implies) the QVD file that the particular row should be written to. This file has a total of 8 different QVD files

Can anyone thing of any way of creating these QVDs?

I have been racking my brain and cannot find a way.

Thanks in advance

Alexis

*** File not empty now - Thanks Rob ****

Re: One QlikView data file = multiple QVDs

rwunderlich — Wed, 27 Aug 2014 19:02:09 GMT

The qvw you posted is empty.

Re: One QlikView data file = multiple QVDs

alexis — Wed, 27 Aug 2014 19:19:41 GMT

Thanks Rob - reloaded - try now!

Re: One QlikView data file = multiple QVDs

Wed, 27 Aug 2014 19:21:18 GMT

If all your data is contained in one table and you want to write different parts of the table to a different file:

//Script

[Data Table];

//create a string with all the file names:

QVDFileNames:

Load chr(39) & concat(distinct QVDFilename, chr(39) & ',' & chr(39)) & chr(39) as QVDFileNames

Resident [Data Table];

//put them in a var

LET vQVDFileName = Peek('QVDFileNames', 0, 'QVDFileNames');

//drop the table with file names

drop table QVDFileNames;

//Create a loop

FOR Each vQVDFileName in $(vQVDFileName)

//Filter out the table:

QVDToStore:

NoConcatenate

LOAD * Resident [Data Table] where QVDFileName = '$(vQVDFileName)';

//Store the sub-table into QVD

STORE QVDToStore into '$(vQVDFileName)'.qvd (QVD);

//Drop the sub table

DROP Table QVDToStore;

//next vQVDFileName

//drop the original table

DROP TABLE [Data Table];

Is this what you're looking for?

Re: One QlikView data file = multiple QVDs

Wed, 27 Aug 2014 19:31:34 GMT

Attached.

Re: One QlikView data file = multiple QVDs

alexis — Wed, 27 Aug 2014 19:42:29 GMT

On paper that is precisely what I want - let me try on my original application and revert.

I'm very optimistic 🙂

Thanks again

Alexis

Re: One QlikView data file = multiple QVDs

alexis — Wed, 27 Aug 2014 19:48:25 GMT

Clay that was PERFECT.

Exactly what I was after - thank you very much..

Alexis

Re: One QlikView data file = multiple QVDs

Wed, 27 Aug 2014 19:50:47 GMT

It might need some slight tweaking, especially around the store-statement, but it should work. Let me know.

C ;o)

Re: One QlikView data file = multiple QVDs

Wed, 27 Aug 2014 19:53:13 GMT

No worries.

C ;o)