How to concatinate records goroupping by value

[Anonymous]

Hello!

I new in qlik community and I apologize for the trivial question.

I have dataset:

1	a
1	b
1	c
2	a
2	f
3	c
3	m

And I need to get:

1	a, b, c
2	a, f
3	c, m

How can I do it in data loader?

Thank you very much.

[MarcoWedel]

Concat - chart function ‒ QlikView

hope this helps

regards

Marco

[swuehl · Accepted solution]

In the LOAD script, use a LOAD with an aggregation function and a GROUP BY clause, like

LOAD

    YourNumericFieldName,

    Concat( YourCharFieldName, ', ') as ConcatenatedChars

FROM ....

GROUP BY YourNumericFieldName;

[Anonymous]

It works!

Thank you very much!

[Anonymous]

This is a very useful article/

Thanks!