topic Automation problem in Qlik Automate

Automation problem

SebastianDL — Thu, 24 Feb 2022 18:18:06 GMT

Hello

Sorry for my English, I speak Spanish.
I'm new to this automation thing.
What I am trying to do is download some data from a Qlik table to a Google spreadsheet but I get this error "Object data can't be bigger than 100,000 cells" even though I put filters.

I have followed the tutorials that I have found but the first thing I realized is that in my case the names of the variables of the table in "Hystori" do not appear, so I do it myself.

The table is this:

Applying these filters I know that the 100000 cells are not passed, I do not know why that error occurs.

Could it be that I am missing some permission? or am I doing something wrong?

Re: Automation problem

NadiaB — Thu, 24 Feb 2022 20:34:09 GMT

Hi @SebastianDL

From the comment about it seems you believe that the limit is not exceeded, did you proceed with any validation to ensure that the 100,000 cells are not exceeded? If not could it be verified?

If this has been validated and we have an exact number of cells and is definitely not exceeding the limit it is suggested to file a support ticket so it can be further investigated.

Kind Regards.

Re: Automation problem

Emile_Koslowski — Wed, 02 Mar 2022 14:51:12 GMT

Hi @SebastianDL ,

You need to apply selections in the automation before you execute the Get Straight Table Data block. You can do this by using the blocks Select Field Value and Select Field Values By Query.

Selections applied in the Qlik Sense UI are not available in the automation. The reason for this is that automations use different sessions than the UI. More information on this can be found here: Session delays

Kind regards,
Emile

Re: Automation problem

SebastianDL — Thu, 03 Mar 2022 11:52:22 GMT

Thanks! It's what I needed.

Re: Automation problem

Napus — Fri, 21 Apr 2023 07:27:22 GMT

Can I ask if you can send your ultimate solution, I need to do the same thing but i am very new to Qlik Automation. thanks