topic Re: QVD Creating concepts in QlikView

QVD Creating concepts

madhubabu — Tue, 15 Sep 2015 01:26:37 GMT

Hi All,

I have 20 tables. I Have to create them into QVD'S. I don't want to write store command for each & every table. Is there any way to create qvd's for all the 20 tables at a time.

Thanks in advance

Madhu

Re: QVD Creating concepts

qlikviewwizard — Tue, 15 Sep 2015 01:46:30 GMT

Hi Madhu,

Yes, It is possible.

Please check this document.

Automatic Loading Tables and QVDs

Re: QVD Creating concepts

qlikviewwizard — Wed, 16 Sep 2015 01:23:52 GMT

Hi Madhu,

Did you get the useful info?

Re: QVD Creating concepts

marcus_sommer — Wed, 16 Sep 2015 06:15:53 GMT

You could use a loop like this:

for i = 1 to NoOfTables() - 1

let t = TableName($(i));

store [$(t)] into [$(t).qvd] (qvd);

But often it's better to store (and drop) a table at that moment that they is created and not to store all tables before finishing the reload-script then in this case all tables remain into the RAM until the end. For this you could use a sub-statement like this:

sub StoreAndDrop(vTableName, vSuffix, vQVDFolder, vDrop)

store [$(vTableName)] into [$(vQVDFolder)\$(vTableName)$(vSuffix).qvd] (qvd);

if '$(vDrop)' = 'drop' then

drop table [$(vTableName)];

end if

end sub

call StoreAndDrop('YourTable', '', '.\', 'drop')

- Marcus