Loops in a script

[doespirito]

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

[rubenmarin · Accepted solution]

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.

[doespirito]

Many thanks Ruben,

it's amazing what you can do with so few instructions !

Arnault