Merge multiple rows of the same ID in one column

vkal12 · ‎2023-01-23

Hello everyone,

I know that this question has been asked many times before but I cannot find the right way to achieve the goal in my Qlik Sense app.

This is how my table looks at the beginning:

Out of this table I want to create new colums for each Type where I concatenate the Names for this Type. So the result should look like this:

I do not want to change something within the load script but within the chart / table itself.

I hope someone has an idea for me and can help me with my problem.

Thank you very much in advance!

Or · ‎2023-01-23

Looks like a standard pivot table with the dimensions being ID, Type (pivoted), and Concat(Name, ',') as the measure, if I understand it correctly?