I tried to use UNPIVOT but it doesn’t work. Is UNPIVOT supported? And if not, are there any plans to support it?
Background: This is often required in IoT scenarios where JSON based sensor data needs to be processed. e.g. you often get something like
sensorXYZ:1234 >> [sensor]:[value]
instead you want defined field names like this
UNPIVOT is the (default) way out…
here’s my query…
val for sensor in (