Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Concatenating records into a single field

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
1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Concatenating records into a single field

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