Unpivot in single not with union

Help Query Tuning
1

Hi,
is there a way to do unpivot in single?
and not to use union

2

Hi lior! :wave:

Are you meaning you are trying to unpivot a single table?
I’m thinking unpivot only applies to multiple tables.

Can you provide more detail about your goal so we can further assist?

3

Hi Maria,
I want to unpivot table from a wide table (VendorID, Emp1, Emp2,
Emp3, Emp4, Emp5 ) to long table (VendorID, Emp, value)
see example from microsoft documentation:

image
image868×809 84.4 KB

thanks!

4

Thanks for sharing this Lior.ha! We will look into it. Let me get back to you shortly. Appreciate your patience. Thanks

5

Hi @lior.ha ,

We don’t support UNPIVOT. We do have a feature request open for that, and I will make a note of your use case.

Eric

1 Like
6

hi @hanson , do you have update on UNPIVOT function? thanks

7

We’re still considering doing this but it’s not on our near-term roadmap. What specifically do you want to do with it?