Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
It works!
Thank you very much!
This is a very useful article/
Thanks!