need PIVOT function for Azure Stream Analytics
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.