Convert Multiple Rows into Single using a Separator?

[dmohanty]

Hi All,

I have a data set like this below example:

ID	Country	Group	Stuff
100	USA	Footwear	Boots
100	USA	Footwear	Sandals
100	USA	Footwear	Bellies
100	USA	Footwear	Canvas
200	CAN	Cereals	Rice
200	CAN	Cereals	Wheat
200	CAN	Cereals	Maize

I need this to be converted into like this -

ID	Country	Group	Stuff
100	USA	Footwear	Boots,Sandals,Bellies,Canvas
200	CAN	Cereals	Rice,Wheat,Maize

Could someone please help here?

Regards!

[marcus_sommer · Accepted solution]

This could be done per concat:

Load ID, Country, Group, concat(Stuff, ', ') as Stuff From xyz Group by ID, Country, Group;

- Marcus

[maxgro]

LOAD ID,

    Country,

    Group,

    concat(Stuff, ',') as Stuff

FROM

[https://community.qlik.com/thread/173967]

(html, codepage is 1252, embedded labels, table is @1)

group by ID,      Country,      Group;

[sunny_talwar]

Try this:

Table:

LOAD ID,

    Country,

    Group,

    Stuff

FROM

[https://community.qlik.com/thread/173967]

(html, codepage is 1252, embedded labels, table is @1);

Join(Table)

LOAD ID,

  Country,

  Group,

  Concat(Stuff, ', ') as ConcatStuff

Resident Table

Group By ID, Country, Group;

[dmohanty]

Hey Thank you Marcus, Massimo and Sunny.

This helped. Thanks again for guidance.