topic Re: How do I drop all tables after a Binary Load? in QlikView

How do I drop all tables after a Binary Load?

julioarriaga — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I am creating a small txt file from a huge binary model file and I wish to drop all the information of the binary after the txt is generated, so my application has a manageable size. Right now I can't improve the model to make it smaller.

Thanks in advance.

My sample code is the next one (the Set section was ommitted for the sake of clarity):

Re: How do I drop all tables after a Binary Load?

fkeuroglian — Thu, 20 Jul 2017 23:21:07 GMT

Hi Julio

You can drop your tables only using the DROP TABLE function

After load binary and create your txt, put

Drop table TableName1,TableName2,TableNamexxxx;

Good luck

Re: How do I drop all tables after a Binary Load?

mikeqlikcloud — Fri, 21 Jul 2017 09:09:58 GMT

A dynamic way to drop all tables:

Let myvar = NoOfTables() ;

//Returns the number of tables previously loaded.

FOR x=0 to myvar ;

if not isnull(TableName( 0 )) then

Let locTable = TableName( 0 ) ;

drop table $(locTable);

end if

next ;

Re: How do I drop all tables after a Binary Load?

Fri, 21 Jul 2017 10:37:50 GMT

One thing to be aware of is the subtle distinction between

DROP TABLE X, Y, Z;

DROP TABLE X;

DROP TABLE Y;

DROP TABLE Z;

The first one above on a single line is more efficient. Should only be applicable/noticeable for very large data models, but something to be aware of.