Is there any way in teiid i can apply below transformation..
My view returns below set of rows..
I wanted to get output like below
123 US, UK
basically need comma separated list of countries for each fund.
The simplest with Teiid 8.4 or later:
select fund, cast(string_agg(country, ',') as string) from ... group by fund
There are other ways to aggregate the values, such as creating xml, an array value, json, etc.
Retrieving data ...