I am looking for a way to concatenate the strings of a field within a group by query. So for example, I have a table:
and I wanted to group by serial to get something like:
In PostgreSQL I can accomplish that functionality by the following query:
SELECT serial, string_agg(defect,',')
GROUP BY serial
But in Sisense I cannot find the way to do that.
I'll appreciate your help on this.
Please sign in to leave a comment.