Divide source table in load script

[TomBond77]

Hi experts

I need to extract data via a SAP BW query to QlikSense.

Qlik says: The maximum number of dimensions that can be extracted in a single load script is 49. To extract more than 49 dimensions from a BEx query, divide the extraction into several load scripts.

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Clients...

How would you divide the source table? Example for this table in SAP:

Dimension 1...100, Measures 1...10

I have the first script for dimensions 1...49 and all measures 1...10.

How do I have to add the other scripts?

Many thanks

tom

[TomBond77 · Accepted solution]

solved by Qlik help, outer join is the solution: https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...