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