4 Replies Latest reply: Nov 25, 2013 5:20 PM by Josh Good RSS

    CROSS TABLE

      HI,

      What is the way to create cross table?

      i tried to make 3 columns: ID_NUMBER, NAME, MONTH.

        • Re: CROSS TABLE
          Manish Kachhia

          Use below in script.

           

          TableName:

          CrossTable(Month, DATA, 2)

          LOAD ID_NUMBER,

               NAME,

               Jan,

               Feb,

               Mar,

               Apr,

               May,

               Jun,

               Jul,

               Aug,

               Sep,

               Oct,

               Nov,

               Dec

          FROM ..... your table path...

          • Re: CROSS TABLE
            Manish Kachhia

            Go to the Script Editor..

            Click on Table Files

            Select File from appropriate location.

            Now you can see Table, Header Size, Lables... Make sure you have embedded labels selected

            Click Next Next (i.e. Two Times)

            You will get screen from where you have to select Cross Table

            Write Now Qualifier Fields.. for you 2 (i.e. ID_NUMBER and NAME)   

            Attribute Filed ... for you is Month

            Data Field ... for you is Data or sale or value whatever you want to given name

            OK

            FINISH

            OK

            RELOAD