Binary load, Section Access reduction method

[coleturegroup]

Question, I have a very large data transform we need to repurpose across multiple regions. Each region shares a slice of the contents from the transform data model. My question is can I utilize binary load to only load each regions data model to save space.

For example: the transform data model is 100 GiG. Binary load region 1, Binary load region 2, Binary load region 3,....

Each region might only consist of 10 GIG of data resulting in each regions app smaller then the transform app model in size.

Can this be done and how might that be executed?

[rubenmarin]

Hi, only one binary is allowed by document, you can do a binary load of a document with allthe data and then reduce it doing some inner joins.

I think the ost common scenario to solve this is having qvds, you can have a qvd for each Region-Table, and the document of each region only load the data from the qvds of it's region.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/work-with-QVD-f...