1 Reply Latest reply: Jun 28, 2016 6:05 AM by vikas mahajan RSS

    Importing specific named tables from excel and then cross table

    Karsten Løvlid

      Hi,

       

      im going to start using weather data, and it comes in this format per month in the same file. Lets call it weather.xls.

       

       

      Element123456789101112131415161718192021222324252627282930
      Normal TAM12,412,512,612,712,812,812,9131313,113,113,213,313,313,413,413,413,513,513,613,613,613,713,713,713,813,813,813,913,9
      TAM13,416,920,418,718,119,314,414,61212,213,514,715,717,61917,616,614,51212,314,51616,515,614,815,3
      RR1,520000000012,800000,30,30011,80,400,210,30,37,8

       

      I've made named fields inside the excel file:

      January2016

      February2016

      March2016

      April2016

      May2016

      June2016

      ....

       

       

      What i want to do:

      1. Read only the tablenames in the list above.

      2. Cross table the day of the month (1-30/31).

      3. End result cross table: get a vertical list of normal TAM, TAM, RR with the corresponding day of the month. (1,2,3,4,5,6,7).

       

      ElementNormal TAMTAMRR
      112,413,41,5
      212,516,92
      312,620,40

       

      4. Add for each filelist [lib://desktop/weather*.xls] including the specific table names and cross table function.

       

      I've only done cross table with two rows before and i don't know how to use import a named list of table names from excel file.

      Hope you can help me out on this one.

       

       

      Thanks,