1 Reply Latest reply on Apr 28, 2014 11:01 AM by Steven Hawkins

    how to denormalize data in teiid

    Krishna M Newbie


      Hi,

       

      Is there any way in teiid i can apply below transformation..

       

      My view returns below set of rows..

       

      FUND     COUNTRY

      123          US

      123          UK

      345          US

      345          UK

      345          IE

       

      I wanted to get output like below

       

      FUND     COUNTRY

      123          US, UK

      345          US,UK,IE

       

      basically need comma separated list of countries for each fund.