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