topic Loops in a script in QlikView

Loops in a script

doespirito — Wed, 02 May 2018 15:52:22 GMT

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

Re: Loops in a script

rubenmarin — Wed, 02 May 2018 16:05:17 GMT

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.

Re: Loops in a script

doespirito — Thu, 03 May 2018 07:07:55 GMT

Many thanks Ruben,

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

Arnault