Question
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 dont use the aggregation so Im not able to use my table as the case table (would be a n:n connection then).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.