How to resolve "GROUP_CONCAT is not being recognized" error in TIBCO Data Virtualization?

How to resolve "GROUP_CONCAT is not being recognized" error in TIBCO Data Virtualization?

book

Article ID: KB0070965

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

When using the GROUP_CONCAT as referenced below, TDV throws an error "GROUP_CONCAT is not being recognized"
  
SELECT customerId, 
GROUP_CONCAT(DISTINCT customerName ORDER BY customerName ASC SEPARATOR ';') 
FROM t;

Issue/Introduction

This article provides an example of using the GROUP_CONCAT function in TIBCO Data Virtualization.

Environment

All Supported Environments

Resolution

Use the below query which has the correct syntax for GROUP_CONCAT: 
select customerId, 
GROUP_CONCAT(customerName,';') 
as customer 
from t group by customerId;
Powered by Wolken Software