Concat strings at group by

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
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.



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).