Concatenating records into a single field

[#1]

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:

Stock	Description
ABC123	ABC Stock

Table 2:

Stock	Job Number
ABC123	11234
ABC123	22324
ABC123	33254
ABC123	44265

Table 3:

Stock	Job Numbers
ABC123	11234, 22324, 33254, 44265

[Gysbert_Wassenaar · Accepted solution]

Table1:

LOAD * INLINE [

    Stock,    Description

    ABC123, ABC Stock

];

Table2:

LOAD * INLINE [

    Stock,    Job Number

    ABC123, 11234

    ABC123, 22324

    ABC123, 33254

    ABC123, 44265

];

Table3:

Join (Table1)

LOAD Stock, concat([Job Number],', ') as [Job Numbers]

resident Table2

group by Stock;