3 Replies Latest reply: Sep 13, 2017 3:11 AM by Hugo Mallaroni RSS

    Merge two row of a table in Qlik sense

    Hugo Mallaroni

      Hi,

       

      I need to merge some cells from differents rows from a table, is it possible?

       

      My data looks something like the below :

      NameFirstnameCodeValid
      Name 1Firstname1Code1yes
      Name 1Firstname1Code2yes

       

      and i want as a result

      NameFirstnameCodeValid
      Name 1Firstname1Code1, Code2yes

       

      I was thinking about using the "concat" function, but it seems it wrong the dimension...

       

      is there any way to do this with many lines?

       

      Thanks