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
03-10-2019 04:53:49 -0400

2 Answers

Just found the 'GROUP_CONCAT' function which works
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]( function with the appropriate separator. You could also take a look at a similar [Community Q&A]( 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