topic Re: Dynamically add items to variable in Qlik Automate

Dynamically add items to variable

bchip01 — Mon, 08 Apr 2024 13:20:38 GMT

Hi All

Is it possible to dynamically add items to a list of variables. Context:

I have 100,000 rows, by 4 columns of data I have to export to a google sheet.

Due to the limitation I can only export 100,000 cells at a time (or in this scenario 100k/4 = 25k rows at a time)

Ive added a grouping in the data ( Ceil(RowNo() / 4 ) so that I can create a filter to limit it to 100k cells at a time and then I upload the data. This works fine. So theres an extra field called RowGroup with values 1,2,3,4.

However when I create the automation I have to manually add Items to a variable and then the rest is automated by looping over the numbers 1..4. Is there anyway that I can dynamically add these 1..4 -

like getFieldValues( RowGroup) and insert as list into a variable?

Re: Dynamically add items to variable

AfeefaTk — Wed, 22 May 2024 10:43:37 GMT

Hi @bchip01

Can you please check this article

https://community.qlik.com/t5/Official-Support-Articles/How-to-export-more-than-100000-cells-using-the-Get-Straight/tac-p/2427309

And see if it helps you to export data of more than 100k cells using the Get Straight Table Data block.

Thanks

Re: Dynamically add items to variable

bchip01 — Thu, 30 May 2024 10:50:39 GMT

Thank you

This article also helped a lot.
https://withdave.com/for-loop-application-automation/