Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Merging data into single cell Pivot

Hi Team,

I have data with three dimensions . I want to merge the data of a column into single row. Please find below screenshot for easy understanding of requirement.

Example.png

Regards,

Sai Krishna.

1 Solution

Accepted Solutions
3 Replies
sunny_talwar

Not applicable
Author

Temp:

Load * Inline [

Sno, ProductFamily, Product, Category, Qty

1, Accessories, Mouse, Hardware, 2

2, Accessories, Keyboard, Hardware, 3

3, Accessories, Headset, Hardware, 1

4, Computer, Windows, Software, 1

5, Computer, Office, Software, 1

];

Final:

Load

     ProductFamily, Category,

     Concat(Product, ',') as Product,

     sum(Qty) as Qty

     Resident Temp

     Group by ProductFamily, Category;

    

Drop table Temp;

Capture.PNG

sorrakis01
Specialist
Specialist

HI,

It's the same question and the same example

Regards,