Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


1 Solution

Accepted Solutions
Gysbert_Wassenaar

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;


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

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;


talk is cheap, supply exceeds demand