topic Re: For loop to generate data in QlikView

For loop to generate data

rakesh_kumar — Mon, 08 Jun 2015 08:11:58 GMT

Hi Guys,

I am trying to create a table with data as follows:

For 1=1 to 1000000

NewTable:

Load $(i) as Counter

AutoGenerate 1;

When the above code is executed its taking nearly 20 minutes to create a table with 1 million rows. Is there any other efficient way of modifying code to reduce the time taken for the creation of the above table?

Thanks,

Re: For loop to generate data

petter — Mon, 08 Jun 2015 08:15:42 GMT

LOAD

RecNo() AS Counter

AUTOGENERATE

1000000;

Re: For loop to generate data

rakesh_kumar — Mon, 08 Jun 2015 08:29:46 GMT

Hi Petter,

Thanks for the code and Its very fast now.

Please can you tell why the looping is so slow compared to your approach?

Thanks,

Re: For loop to generate data

ToniKautto — Mon, 08 Jun 2015 08:38:29 GMT

Petter's example generates ONE load statement that contains one million rows.

In your original example you generate 1 million load statements, which then are concatenated into one common table.

Your approach simply adds an enormous amount of processing overhead.

Re: For loop to generate data

Mon, 08 Jun 2015 08:39:59 GMT

Hi Rakesh,

Try like this:

LOAD

RecNo() AS ID

AUTOGENERATE

Ramaya.

Re: For loop to generate data

rakesh_kumar — Mon, 08 Jun 2015 08:41:45 GMT

Thanks Toni for the simple and easy to understand explanation