Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
This could be done per concat:
Load ID, Country, Group, concat(Stuff, ', ') as Stuff From xyz Group by ID, Country, Group;
- Marcus
This could be done per concat:
Load ID, Country, Group, concat(Stuff, ', ') as Stuff From xyz Group by ID, Country, Group;
- Marcus
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;
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;
Hey Thank you Marcus, Massimo and Sunny.
This helped. Thanks again for guidance.