Discussion Board for collaboration related to QlikView App Development.
I am trying to create a table with data as follows:
For 1=1 to 1000000
Load $(i) as Counter
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?
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.