4 Replies Latest reply: Aug 2, 2012 12:25 PM by Loren Wood RSS

    How to Concatenate several rows into one field by a dimension

      I wondering if you could concatenate several rows from the same column grouped by a dimension. Example:

       

      Date, Comment

      2011-01-01, One

      2011-01-01, Two

      2011-01-01, Three

      2011-01,01, Four

       

      The final result would be:

       

      2011-01-01, One Two Three Four

       

      In this case I am reading the data via a webfile by using the XML parser.