How to transpose data?

How can i transpose data from rows to columns? Is it possible in Dremio?

My query collect a data as a one-row-table with columns Indicator1, Indicator2, … and i need to represent it as a report
Indicator1 Value
Indicator2 Value

3 Likes

Transpose/pivot/unpivot are not current available functions in Dremio. However, they have been requested before and are actively being considered in our roadmap.

Thank you!
Have a nice day!

Transposition would be very helpful. Especially over a specified range of data.

1 Like

Agreed, this would be so helpful. Please let us know when UNPIVOT will become available!

Even we have this uses case to pivot and unpivot