You can translate the question and the replies:

Create a Comma Seperated List (CSV) as part of query resultsL

Is it possible to convert a list of values into a csv string as part of query result? Ex: **Customer | Item** John | Glove John | Bat Desired output: **Customer | Items** John | Glove, Bat In SQL Server, i would use syntax like shown in this article. [](http://)
23-08-2018 09:48:26 -0400

1 Answer

Hi, I'd try to concatenate field values using the GROUP\_CONCAT function in Virtual DataPort. For example, > GROUP_CONCAT(‘<row separator>’,<field_name>) You can have a look at the [GROUP_CONCAT]( section of Virtual DataPort VQL guide. Hope this helps!
Denodo Team
28-08-2018 03:55:24 -0400
You must sign in to add an answer. If you do not have an account, you can register here