devSus on Tue, 17 Apr 2018 10:25:00
I want to process IOT hub input data conditionally ie. based on type of message. So i need to process data in terms of if-else conditions. How can i write if-else statement in stream analytics query?
Alex Raizman - MSFT on Tue, 17 Apr 2018 16:58:34
You can use CASE ... WHEN expression as described here.
JasonHowell on Tue, 17 Apr 2018 21:20:33
Another pattern is to use two separate queries (in the same job if needed, or separate job for more isolation) doing the conditional logic in the where clause: