1 Reply Latest reply on Mar 19, 2018 11:55 AM by Ramesh Reddy

    Unpivot excel sheet

    Marc Kusters Newbie

      I have a excel sheet that I use as datasource. Loading this in Teiid Designer is no problem. However, the excel sheet has a lot of columns (300+) that are pivoted. These need to be unpivoted.

       

      I searched around to find a generic solution for this but couldn't find any. The ideal situation would be that I can use a procedure to unpivot a range of columns and use the output those in an normal SQL statement.

      At the moment I don't have a good clue on how and where to start, is there any way to solve this in Teiid?

       

      Thanks!