1 Reply Latest reply: Apr 5, 2013 7:15 AM by Gysbert Wassenaar RSS

    Concatenating records into a single field

      Hi,

       

      I need to create a new table (Table 3) from 'Table 1' & 'Table 2'. I basically need to take the job numbers from multiple records in 'Table 2', concatenate them, then add it as a single field in 'Table 1'. Is there a way to do this in qlikview? Thanks

       

      Table 1:

      StockDescription
      ABC123ABC Stock


       

      Table 2:

      Stock
      Job Number
      ABC12311234
      ABC12322324
      ABC12333254
      ABC12344265

       

      Table 3:

      Stock
      Job Numbers
      ABC12311234, 22324, 33254, 44265