Skip to main content
Question

Concat strings at group by

  • Nov 4, 2020 9:53 AM UTC
  • 2 replies
  • 154 views

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

2 replies

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

  • Nov 4, 2020 1:33 PM UTC
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).