How can I generate a huge EXCEL with 2000 columns?
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 .