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
Page 1 / 1
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
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).
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.