I am trying to use group_concat as present as present in https://github.com/vertica/Vertica-Extension-Packages/blob/master/strings_package/src/GroupConcat.cpp 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:
select
id
, group_concat(name)
, group_concat(city)
from dummy_table;
Is there a way to resolve this please?
