Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
firmographs
Partner - Contributor III
Partner - Contributor III

Qlik Sense concatenating multiple rows into one cell

We have data in rows, like this:

A, 1

A, 2

A, 3

B, 1

B, 6

 

For  a CRM-related project, we want to concatenate all of the "A" and "B" data together, in a cell, that would look like this:

A, 1 2 3

B, 1 6

In other words, we would combine the second column of data in a single table cell for each distinct value of the first column.  

Is this achievable using a load script with Qlik Sense Enterprise?

Labels (2)
1 Reply
Vegar
MVP
MVP

Try this approach.

 

LOAD

LetterField as Letter,

Concat(distinct NumberField, ' ') as Numbers

FROM Data

GROUP BY  LetterField;