4 Replies Latest reply: Oct 9, 2013 5:53 AM by Quy Thanh Lê RSS

    How to concatenate columns in Qlikview

      Hi,

       

      I'm a beginner in QlikView and I need some help to understand concatenation...

      I have a table like this :

      Table_A (Rot_NB, FL_NB, Dep, Arr, Date)

      RowRot_NbFL_NBDepArrDate
      111199AABB
      211199BBCC
      311198CCDD
      422288CCGG
      522288GGCC
      633377FFDD
      733378DDFF

       

      I would like to concatenate :

      • All the FL_NB for one Rot_NB in the same line
      • All the connections Dep-Arr for one Rot_NB to have only one line (order by date)

      == To have : 111, 99/99/98, AA-BB-CC-DD, Date ... Or 222, 88/88, CC-GG-CC, Date

       

      Is it possible to do this in QlikView (in a script) ?

      Thank you in advance for your help