topic rescue old data from qvd in QlikView

rescue old data from qvd

Fri, 07 Jun 2013 09:51:47 GMT

Hi,

I got an old qvw which displays data, that I cant reload from source, because source data has gone.

Is there a chance to store or extracts old data from the qvw?

Thanks in advance

Klaus

Re: rescue old data from qvd

Gysbert_Wassenaar — Fri, 07 Jun 2013 09:57:04 GMT

You can use the binary statement to load data from a qvw file into another qvw file. You can then store the data into qvd's if you want (or in csv). The binary statements has to be the absolute first line in your script. You can use something like below to load the data from a qvw file and create qvd's for every table. Change your.qvw and c:\temp\extract to what's appropriate for you.

BINARY your.qvw;

Directory c:\temp\extract;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

Re: rescue old data from qvd

Fri, 07 Jun 2013 11:25:48 GMT

Thank you Gysbert,

that worked wonderful.

Have a nice weekend

Klaus