0 Replies Latest reply: Nov 25, 2013 5:23 PM by marcelo siffert RSS

    How can I generate a huge EXCEL with 2000 columns?

    marcelo siffert

      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)