Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Binary Load to Create QVD's

Not applicable

Binary Load to Create QVD's

Have you ever had a source file you needed to play with but have not had the QVD's to perform a reload?

No Problem use the script below: -

FOR i=0 TO $(vTableNumber)

LET vTableName =TableName($(i));

TRACE EXPORTING '$(vTableName)';

STORE '$(vTableName)' INTO [$(vTableName).QVD] (QVD);

IF $(i)=0 THEN

  LET vDropString = '[$(vTableName)]';

  ELSE 

  LET vDropString = '[$(vTableName)]'&','&'$(vDropString)';

ENDIF

NEXT

DROP TABLES $(vDropString);

LET vDropString = NULL();

LET i = NULL();

LET vTableName = NULL();

LET vTableNumber = NULL();

//**************************************************************************************

//Updated code to allow for spaces in table names per below comments

//New version is slightly refined with a single loop

//**************************************************************************************

Tags (3)
Attachments
Comments
msteedle
Contributor

You may want to add square brackets around the QVD reference, in case the table name has spaces. This would prevent an error from occurring.

[$(vTableName).QVD]


There are ways to combine the two loops into one, as well.

Not applicable

New version updated to reduce looping.

Not applicable

nice one

erich_shiino
Honored Contributor

You can also include this script on the end of the app and use partial reload.

That's why it's important to mark the prohibit binary load option if you want to protect the data on the qvw

Not applicable

Felim.

Every now and then, someone posts something so simple, but so useful.

This is one of those.

Many thanks

Not applicable

Very true Erich, for all those sneaky espionage types it is a tool of destruction... mwahahaha

alex_millan
Contributor III

Thanks for sharing

Version history
Revision #:
1 of 1
Last update:
‎04-24-2014 09:11 AM
Updated by: