3 Replies Latest reply: Mar 7, 2012 5:34 AM by Celambarasan Adhimulam RSS

    Combining data fields in a crosstable load - drops an attribute field.

    Joe Kirwan

      Hi

       

      I have 2 attribute columns, and 4 data columns.

       

      I want to combine the 4 data columns into 2 new columns, each contaiining 2 of the old columns.

       

       

      Crosstable (SalesItem,Data,2)

       

      LOAD Site,

           Month,

           ColA + ColB as Item1,

           ColC + ColD as Item2

       

      FROM etc

       

      The problem is that it does not seem to load Month.

       

      When I do a straight Crosstable load, as follows, I don't have a problem (but I have too many data types)

       

      Crosstable (SalesItem,Data,2)

       

      LOAD Site,

           Month,

           ColA,

           ColB,

           ColC,

           ColD

       

      FROM etc

       

      Any ideas?