1 Reply Latest reply: May 26, 2013 9:05 AM by Nagaian Krishnamoorthy RSS

    Cross Table?

      Hi All,

      Please i have this cross table

      JulySales
      Cairo200
      Alex300
      AugustSales
      Cairo400
      Alex500

       

      i nedd to load it and make (july,August) as dimension "Month"

      and make (Cairo,Alex) as dimension "Country"

       

      How to do that?

        • Re: Cross Table?
          Nagaian Krishnamoorthy

          For your test data , the following script will help:

           

          Temp:

          LOAD *, If(Sales='Sales',City, Peek(Month)) as Month;

          load * Inline [

          City, Sales

          July,Sales

          Cairo,200

          Alex,300

          August,Sales

          Cairo,400

          Alex,500

          ];

           

          Data:

          NoConcatenate

          LOAD City, Sales, Month Resident Temp

          Where Sales <> 'Sales';

          DROP Table Temp;