1 Reply Latest reply: Sep 22, 2011 5:37 PM by DJ Norton RSS

    Reverse-Crosstable Transformation?

      Hi Everyone,

       

      I've got a data set, straight from a quirky source data system, that looks like the result of a crosstable transformation.... but shouldn't.  Basically, I have too many rows that should be columns -- so, what should be field names are appearing as row values in single a "Type" column.

       

      If the number of Type values were small and static, I'd just do a series of LOAD * WHERE Type =1, 2, 3, etc... and concatenate the tables.  However...

       

      What's the simplest way to perform a reverse-crosstable transformation?  Difficulty is there are also three preceding fields, including identity values, that shouldn't pivot.

       

      Thanks,

      DJ