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.