Discussion board where members can get started with Qlik Sense.
We have data in rows, like this:
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.
LetterField as Letter,
Concat(distinct NumberField, ' ') as Numbers
GROUP BY LetterField;