topic Re: Concatenating records into a single field in QlikView

Concatenating records into a single field

Fri, 05 Apr 2013 11:10:48 GMT

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

Re: Concatenating records into a single field

Gysbert_Wassenaar — Fri, 05 Apr 2013 11:13:55 GMT

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;