topic Re: Convert Multiple Rows into Single using a Separator? in QlikView

Convert Multiple Rows into Single using a Separator?

dmohanty — Fri, 24 Jul 2015 18:53:12 GMT

Hi All,

I have a data set like this below example:

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 — Fri, 24 Jul 2015 18:55:06 GMT

This could be done per concat:

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

- Marcus

maxgro — Fri, 24 Jul 2015 18:55:21 GMT

LOAD ID,

Country,

Group,

concat(Stuff, ',') as Stuff

FROM

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

group by ID, Country, Group;

sunny_talwar — Fri, 24 Jul 2015 18:57:26 GMT

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 — Fri, 24 Jul 2015 19:02:26 GMT

Hey Thank you Marcus, Massimo and Sunny.

This helped. Thanks again for guidance.