2 Replies Latest reply on Sep 24, 2013 9:57 AM by piero giansanti

    Is it possible to create a field where instead of a mathematical operation (average, median, stdev, sum....) all the 'values' are concatenated, using a special character (i.e. ";") between them?

    piero giansanti

      Hi all,

       

      I am currently working with a data set like this

       

      UID0001a10
      UID0002a20
      UID0003b5
      UID0004a30
      UID0005c5
      UID0006d5

       

      What I would like to do is to sum values in column 3 on the basis of the values in column 2 (a,b,c and d).

      a60
      b5
      c5
      d5

       

      This is easy, ok! However, at the same time, I would like to concatenate the values in column 1, still on the basis of the values in column 2,to obtain this

       

      a60UID0001;UID0002;UID0004
      b5UID0003
      c5UID0005
      d5UID0006

       

      How can I do this?

       

       

      Thank you in advance for your help.