topic Re: Binary Loading in QlikView

Binary Loading

Anonymous — Mon, 03 Nov 2014 22:33:04 GMT

I have a qvw file with images i would like to use in my application. Is there a way to load the images only without other tables using a binary load? Or is there another way around this requirement?

Thanking you in advance.

regards

Re: Binary Loading

maxgro — Mon, 03 Nov 2014 22:41:58 GMT

binary load load all tables

if you don't want some of the tables loaded,

after binalry load use

drop tables table1, table2, .....

Re: Binary Loading

Mon, 03 Nov 2014 22:45:34 GMT

if images is just a table in one of your applications. You can STORE it as QVD file then load this new QVD in your script load statement.

STORE Images into Images.qvd (qvd);

Re: Re: Binary Loading

Anonymous — Mon, 03 Nov 2014 22:58:34 GMT

Thank you very much, however, i am getting a script error as per the attached. Please assist further.

Regards.

Chris

Re: Binary Loading

maxgro — Mon, 03 Nov 2014 23:03:56 GMT

maybe you try to drop a table and that table doesn't exist

binary load .....;

drop Table TableA, TableB, NotExistentTable;

Re: Binary Loading

Mon, 03 Nov 2014 23:05:51 GMT

There could be just an error in your script, a missed semicolon, or a closing braces etc.

Since it is not giving you table name to drop.

Or, After binary load you might be misspelling table names to be dropped.

They are case sensitive, table names field names should matched exactly.

Comment DROP statement and see what is happening and what are the final table names after Binary Load

Re: Binary Loading

Anonymous — Mon, 03 Nov 2014 23:13:55 GMT

Many thanks, it worked, i had included invalid tables in the drop statement.

Regards.

Re: Binary Loading

Anonymous — Mon, 03 Nov 2014 23:15:17 GMT

Many thanks, i had invalid tables in the drop tables statement.

Regards.

Chris

Re: Binary Loading

Mon, 03 Nov 2014 23:19:30 GMT

Good job ..

I don't get credit 🙂

Re: Binary Loading

Anonymous — Mon, 03 Nov 2014 23:28:53 GMT

Ok noted