Export more than 100 000 cells from a straight table

[Jakkie]

Hi Community

I've recently started looking into Qlik Application Automation and one of the things we would like to do is automate daily exports to Excel of our data. Unfortunately, it seems the limit is 100 000 cells and we have more data than this. Since the exports are for a 3rd party, we don't have the option to change the format.

Is there any way to get around the limitation?

Thanks in advance

[Emile_Koslowski · Accepted solution]

Hi,

Qlik Application Automation is not built to handle big amounts of data, that's why we implemented the limit of 100k cells. More information on the limits for automations.

That being said, you could loop over the values of a certain field in your app. Then loop over the values and for each value, you apply a selection and you execute the Get Straight Table Data block. This will now only contain data that's in the selection. After the Get Straight Table Data block is finished, I suggest you execute a Clear Selection block to make sure there are no selections for the next execution of the loop. 

Kind regards,
Emile