2 Replies Latest reply: Aug 22, 2013 6:58 AM by Marcus Malinow RSS

    Crosstable load with variable number of columns

    Marcus Malinow

      Hi,

       

      I am loading a crosstable from excel with a pretty typical format. Across the top I have cities, and along the side I have measures. I'd like to be able to write my script in such a way that as new cities are added to the spreadsheet, I don't need to rewrite the load script. Is this possible?

       

      Excel file looks something like this:

       

      LondonDublinToronto
      Cash1055
      VAT.2.23

       

      Script looks something like:

       

      CrossTable(London, Data)
      LOAD F1,
          
      London,
          
      Dublin,
          
      Toronto
      FROM .\data.xlsx (ooxml, embedded labels, table is Sheet1);

       

      Thanks,

       

      Marcus