Dynamically add items to variable

[bchip01]

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?

[AfeefaTk · Accepted solution]

Hi @bchip01 

Can you please check this article

https://community.qlik.com/t5/Official-Support-Articles/How-to-export-more-than-100000-cells-using-t...

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

Thanks

[bchip01]

Thank you

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