Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to do the opposite of what Henric Cronström demonstrates in this topic: https://community.qlik.com/blogs/qlikviewdesignblog/2013/09/02/loops-in-the-script
I would like to concatenate the skills in the same field.
See the qvw fil attached for datas.
Can someone help me do that?
Thank you very much,
Arnault
Hi, just use concat(field, ','):
Individuals_skills:
LOAD [Emplyee no], Concat(skills, ',') as skills
Group By [Emplyee no];
LOAD * INLINE [
Emplyee no, skills
159, Economics
159, Pharmacology
163, Marketing
163, Siciology
163, Spanish
174, Bookkeeping
174, particle physics
210, Economics
210, Marketings
];
Keeping skills separated uses less space and allows simpler list boxes for selections.
Hi, just use concat(field, ','):
Individuals_skills:
LOAD [Emplyee no], Concat(skills, ',') as skills
Group By [Emplyee no];
LOAD * INLINE [
Emplyee no, skills
159, Economics
159, Pharmacology
163, Marketing
163, Siciology
163, Spanish
174, Bookkeeping
174, particle physics
210, Economics
210, Marketings
];
Keeping skills separated uses less space and allows simpler list boxes for selections.
Many thanks Ruben,
it's amazing what you can do with so few instructions !
Arnault