Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose I have a COLORS table with these values that I load into QlikView:
RED
YELLOW
BLUE
GREEN
How can I turn it into a comma delimited list, for example;
RED,YELLOW,BLUE,GREEN
(similar to what is discussed here) http://www.sqlbook.com/SQL/Create-comma-delimited-list-27.aspx
Suggestions? Is there a function that does this? Thanks in advance.
In an expression, you can use Concat.
=concat(Color, ', ')
Perfect - thanks.