3 Replies Latest reply: Jul 11, 2013 5:54 AM by Mohit Sharma RSS

    Crosstable question

    Russell Angus

      I have a table in excel which has one dimension as the rows, and another dimension as the columns. The data values are all either true or false.

      E.g.

                Dim2

      Dim1     X     Y     Z     and so on...

      A         T     F     F

              F     T     F

      C         F     T     T

      and so on...

       

      So far so good...

       

      When I use the crosstable function in the load statement it includes the first column header as one of the data values, in my example above the X.

      What I want is:

       

      Dim1     Dim2     Data

      A          X          T

      A          Y          F

      A          Z          F

      etc

       

      Can anyone help?