How to transpose data?

1

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
…

5 Likes
2

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

3

Thank you!
Have a nice day!

4

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

1 Like
5

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

6

Even we have this uses case to pivot and unpivot

7

is PIVOT and UNPIVOT available??

8

@capihacendado Not yet

9

@balaji.ramaswamy is the Pivot function now available in Dremio? We are on the v15 version - enterprise edition.

10

@priyanka Yes on >v19.0, See:

1 Like