Server: how to load from previously created app in the load script?

[ziabobaz]

Hi

I have my MainApp, which contains full clean data made of dozens of tables. It is stores in QS Server.

I created a SecondApp for local purposes, where I want to load only certain tables and fields from the MainApp.

How do I do this, given I don't have physical qvd or qvf, which can be referenced in the script.

Thank you!

[Channa]

u can do binary load

after doing binary load delete unwanted tables in your local model

try

[Vegar]

Yes, you could do as @Channa suggests.
You may read up on binary load on the Qlik Help site
https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

If you only are interested in a limited amount of these tables or only a limited amount of data in the data model then you should at least consider implementing an QVD approach.
/Vegar

[ziabobaz]

You cannot use binary to load data from an app on the same Qlik Sense Enterprise deployment by referring to the app ID. You can only load from a .qvf file

It seems not posible to me unfortunately..

i cant refer to an app

[Vegar]

What about the other suggestion, to let your master data application store its tables into QVD files? You could easily access and load the data with great speed into your new application?

This is most likely how I would have handle this scenario.

[rwunderlich]

Here is a script loop you can add to the end of your master app to store all tables to QVD.

FOR i = NoOfTables()-1 to 0 step -1
  LET vTableName = TableName($(i));
  LET vOutfile = '$(vTableName).qvd';
  STORE [$(vTableName)] INTO lib://qvd/[$(vOutfile)] (qvd);
NEXT i

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[ziabobaz]

Yes, it worked bofore I asked.
I just wanted to have more convenient solution

thanks

[ziabobaz]

Thanks, Rob