Azure stream analytics custom output data with CASE statement

I have tried serval SQL query, but cant achieve your requirement. I think it is impossible because you need group by sessionId, but there is no Aggregate Functions can get this format.

"data": {
        "North America": 0,
        "South America": 0,
        "Europe": 0,
        "Russia": 0,
        "Africa": 1,
        "India": 0,
        "China": 0,
        "Oceania": 0, 

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top