1 Reply Latest reply: Mar 20, 2012 11:50 PM by ssha 324 RSS

    excel source problem

      hi,

       

      i have a problem with regards to my source. how can i load this so that i will only have a moth field instead of jan, feb mar etc..

       

      see attached file

        • Re: excel source problem

          Hi,

           

          You need to do a cross table. Use script below

           

          Forums:

          CrossTable(Month, Val, 5)
          LOAD Field1,
          Field2,
          Field3,
          Year,
          Field4,
          1,
          2,
          3,
          4,
          5,
          6,
          7,
          8,
          9,
          10,
          11,
          12
          FROM
          C:\Downloads\forums.xlsx
          (
          ooxml, embedded labels, table is Sheet1);