I want to do a simple concatenation of list to get string value, However I am struggling to do the same. For functionality I want to implement I have requirement of concatenating multiple columns together, but one of the column is coming from aggregate function collect, which is preventing me from concatenating values of a row. I am trying to do something like this:
with [2,4,5,7] as a, "test" as name unwind a as x return name + " | " + toString(collect(toString(x)))
This is syntactically wrong but expected output is like
"test | 2,4,5,7"
Can someone please help me? Thank you in advance
P.S this is just one row example, there are going to be multiple rows with different a's and different name
Solved! Go to Solution.