How can I generate a huge EXCEL with 2000 columns?

marcelostb — Mon, 25 Nov 2013 22:23:28 GMT

I need to read a QVD and generate information that will be migrated to EXCEL.

The EXCEL table will have 1000 rows and 2000 columns. Each line of EXCEL will consist of a single code and each line will have 2000 columns, that indicates a specific information calculated from the QVD .

The QVD source has about 2 million records .

For example :

line 1 = info 1

col 1 = sum ( occurrences ) where M = genre;

col 2 = sum ( occurrences ) where genre = F

col 3 = sum ( occurrences ) where age> 60

...

col 2000 = sum ( occurrences ) where local = X;

We did a test generating a TABLE object in QVW, using "info" as dimension with 3 expressions (3 columns) and it worked.

The concern is if the number of columns (2000) will result in problems (mainly performance) or is there another better to do the process .

Thanks for helping

Looking forward ,

Siffert (ADITI)

topic How can I generate a huge EXCEL with 2000 columns? in QlikView

How can I generate a huge EXCEL with 2000 columns?