Concat strings at group by

Hi,
in data jobs I am doing a transformation and need to concat strings in a group by statement. How can I do this? I tried using google, stackoverflow and so on, tested different methods but was not successful
(https://stackoverflow.com/questions/21053477/concat-group-by-in-vertica-sql/21054041)
Kr, Mara

Hi @MIA92,

could you please share some more details on what exactly you want to do?
For concatenation you normally use ‘||’ in Vertica.

It would be interesting to see what your statement looks like at the moment.

Best,

Justin

Hello Justin, I need to use it as an aggregation method like in the stack overflow link. At the moment I don’t use the aggregation so I’m not able to use my table as the case table (would be a n:n connection then).