Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Leaving tables after binary load

cancel
Showing results for 
Search instead for 
Did you mean: 
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Leaving tables after binary load

Last Update:

Sep 21, 2022 1:07:35 PM

Updated By:

Sue_Macaluso

Created date:

Sep 8, 2020 3:00:46 AM

I found it tricky when it comes to managing tables after Binary load. 

Usually, you do it like this to create a new application like Region sales.qvw with Binary:

 

 

Binary [\\QLIKVIEW\Load\Sales.qvw];

DROP Tables PERMISSIONS, Clients, Dimensions, Expressions;

 

 

In most cases, there are a lot more tables to drop out. 

While working on other projects you add additional tables to the Sales.qvw file. So you have to remember that there are some applications like Region sales.qvw where you have to drop the newly created table.

But instead, you can simply write down the tables you need and want to leave in the data model in Region sales.qvw.

Just create a new SUB in notepad like master_subs.txt:

 

 

SUB Leave_tables(tables)

For t = 0 to NoOfTables() - 1

Tables:
Load TableName($(t)) as TableName
   ,If(Index('$(tables)', TableName($(t))) > 0, 1, 0) as [Do we leave a table]
Autogenerate 1;

Next t;


tmp:
LOAD '[' & Concat(TableName, '], [') & '];' as table_names
Resident Tables
Where [Do we leave a table] = 0
;

DROP Table Tables;

v_drop_tables = Peek('table_names', 0, 'tmp');

DROP Table tmp;
DROP Table $(v_drop_tables);

END SUB

 

 

After that you have to edit your script to this:

 

 

Binary [\\QLIKVIEW\Load\Sales.qvw];

$(Include=\\QLIKVIEW\Data\Master\master_subs.txt);

CALL Leave_tables('Sales, Sales person');

 

 

In this case, you do not have to worry about the newly created tables in the Sales.qvw as those tables might cause some serious data model problems, increase the size of  the Region sales.qvw app.

Contributors
Version history
Last update:
‎2022-09-21 01:07 PM
Updated by: