Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this approach.
LOAD
LetterField as Letter,
Concat(distinct NumberField, ' ') as Numbers
FROM Data
GROUP BY LetterField;