Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

group_concat function not working when used more than once in SQL

I am trying to use group_concat as present as present in to aggregate strings. However, it is not working when I use it more than once in a SQL. For example the SQL statement below failes with the error: ERROR: Cannot specify more than one user-defined transform function in the SELECT list:



,  group_concat(name)

,  group_concat(city)

from dummy_table;

Is there a way to resolve this please?


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.