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

    how to denormalize data in teiid

    Krishna M Newbie



      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.