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!
See if this helps How to transpose/pivot rows as columns in teiid ?