topic Re: Script Help in QlikView

Script Help

Anonymous — Tue, 12 Jan 2016 13:03:15 GMT

Hi All,

I here has a question again. Assume I has following Inline table:

LOAD * INLINE [

ID, PRO

A1, CA

A1, SA

A1, CA

A1, FD

A2, SA

A3, CA

A4, CA

A4, SA

A5, SA

A5, FD

A6, FD

A6, CA

];

How can I come out with this result by using scripting?

Result:

ID	Total Product
A1	CA & SA & FD
A2	SA
A3	CA
A4	CA & SA
A5	SA & FD
A6	FD & CA

Thanks for help.

Regards.

Re: Script Help

sunny_talwar — Tue, 12 Jan 2016 17:07:24 GMT

Try this:

LOAD ID,

Concat(DISTINCT PRO, ' & ') as [Total Product]

Group By ID;

LOAD * INLINE [

ID, PRO

A1, CA

A1, SA

A1, CA

A1, FD

A2, SA

A3, CA

A4, CA

A4, SA

A5, SA

A5, FD

A6, FD

A6, CA

];

Re: Script Help

Anonymous — Wed, 13 Jan 2016 01:03:23 GMT

Hi Sunny,

I get the correct answer.Thanks for help.

Regards.