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. [https://davegugg.wordpress.com/2015/01/29/creating-a-comma-separated-list-with-for-xml-path-and-stuff/](http://)
user
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](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/aggregation_functions#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