need PIVOT function for Azure Stream Analytics
Emiliano Parizzi commented
It's crazy this service doesn't have PIVOT/UNPIVOT while simple SQL Azure/Server does. We certainly need this.
Melissa Winnel commented
I've had trouble aggregating multiple streams but using a udf to change data format worked to do a pivot like function
James White commented
Indeed. My very first attempt at using the tool to aggregate a stream of events ran right into this wall.