Since databricks runtime 12 and spark version 3.3.1, what you PIVOT can be easily UNPIVOT. 

Hubert-Dudek
Databricks MVP

‎01-25-2023 07:14 AM

Since databricks runtime 12 and spark version 3.3.1, what you PIVOT can be easily UNPIVOT.

Screenshot 2023-01-25 161211


My blog: https://databrickster.medium.com/
Preview file
82 KB

Ajay-Pandey
Databricks MVP

‎01-25-2023 09:28 AM

Thanks for sharing

Ajay Kumar Pandey
0 Kudos