cancel
Showing results for 
Search instead for 
Did you mean: 

Unpivot using sparksql

KHK
Partner
Partner

HI 

I have two dimensions, Ensys and CONTROLLER  and two measures KWH and Count(Site ID) .

I want to unpivot both dimensions and measure values  as per below screenshot.

Please let me know how to achieve.

 

KHK_1-1758545328840.png

 

 

 

0 REPLIES 0