You can translate the question and the replies:

LISTAGG function error denodo 8

Hi All, I am getting "LISTAGG is not executable funtion" while using the fucntion to combine the data into single row using below query in denodo 8 . query: SELECT LISTAGG(NAME,'|') WITHIN GROUP (ORDER BY NAME) FROM ( SELECT 'A' NAME UNION SELECT 'B' NAME ) DATA ERROR: SQL Error [31016] [HY000]: Error executing view: Function listagg is not executable Please let me know if i am missing any.
List Listagg
user
21-12-2022 06:18:47 -0500
code

4 Answers

Hi, In order to combine data into a single row in Denodo, I would use the **GROUP_CONCAT** function as this functions similarly to LISTAGG. The syntax of the GROUP_CONCAT function is: GROUP_CONCAT ('<row separator>', <field_name>) You can refer to [GROUP_CONCAT](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/aggregation_functions/aggregation_functions#group-concat) in the **Virtual DataPort VQL Guide** or this similar [community post](https://community.denodo.com/answers/question/details?questionId=9060g0000004EzyAAE&title=Function+similar+to+LISTAGG+in+Oracle) for more information. Hope this helps!
Denodo Team
21-12-2022 21:02:49 -0500
code
Thank you For the quick help. It worked with GROUP_CONCAT function.
user
22-12-2022 03:19:24 -0500
I am trying to create select view using group_contact funciton (group_contact('|',fieldname) ) , it is giving error saying invalid parameter but giving result when i am executing using VQL shell. **error: Invalid parameter types for function 'group_concat': text,text** Plese let me know if i am missing any .
user
22-12-2022 05:36:06 -0500
Hi, The issue you are running into is because you are trying to create a normal field, but GROUP_CONCAT is an aggregate function so you need to create an aggregate field in your selection view. To do this, go to the '*Group By*' tab and enable 'Use group by'. Then in the '*Output*' tab, click on new, select 'New Aggregate Field' and provide the GROUP_CONCAT function. The [Advanced Operations](https://community.denodo.com/tutorials/browse/basics/3adv5aggregation) tutorial will provide more information. Hope this helps!
Denodo Team
23-12-2022 20:22:36 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here