What is Qlik Sense Enterprise alternative to Binary Loads?

[imsushantjain]

Hi,

As Binary Load in not supported on Qlik Sense Enterprise, is there any other approach to achieve the same ?

https://community.qlik.com/t5/Qlik-Sense-Deployment-Management/Any-issues-with-Binary-Loads-in-Multi...

I remember there was a blog for the same on this link, but it seems to be missing after the community upgrade.

https://community.qlik.com/qlik-blogpost/4617

Regards

Sushant

[jonathandienst]

If I recall correctly, the approach was to add code to loop through the tables saving each in turn to QVD files.  Then you can  simply load the QVDs to load an identical data set. And it would not need to be the first line of script, so that's a plus.

To export:

Let vTableCount = NoOfTables();	
For i = 0 to vTableCount - 1
	Let zTable = TableName(i);
	Store [$(zTable)] into [$(vExportPath)\$(zTable).qvd] (qvd);
Next		

And to load:

For Each vFile in FileList('$(vExportPath)\*.qvd')
	Let vTable = SubString(Substring(vFile, '\', -1), '.', 1);
	
	[$(vTable)]:
	LOAD * FROM [$(vFile)] (qvd);
Next 

Make sure vExportPath is defined.