You can translate the question and the replies:

Denodo alternative for TSQL "STUFF.... FOR XML PATH"

Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID ______ 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a comma between each with a pre- and sufix as shown expected result 'ID{12345,23456,34567',..............}' In TSQL i would use STUFF and FOR XML PATH. Does anyone know of a way to achieve this in denodo? thanks in advance
user
03-10-2019 04:53:49 -0400

2 Answers

Just found the 'GROUP_CONCAT' function which works
user
03-10-2019 05:47:35 -0400
Hi, Yes, you are right. In a situation where I need the field values to be concatenated in a single row, I would use the [GROUP_CONCAT](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/aggregation_functions#group-concat) function with the appropriate separator. You could also take a look at a similar [Community Q&A](https://community.denodo.com/answers/question/details?questionId=9060g0000000AqFAAU&title=Create+a+Comma+Seperated+List+%28CSV%29+as+part+of+query+resultsL) for your reference. Have a good day!
Denodo Team
04-10-2019 02:35:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here