Jul 04 2022 08:25 AM
if there a way to project/extend columns conditionally?
scenario:
i want to make a resource query by name, and show some additional information based on resource type.
any hints?
Jul 13 2022 11:35 PM
I think you might create a new column with iif. Here's an example using the StormEvents table:
StormEvents
| where State =="CALIFORNIA"
| distinct EventType, State
| extend ItNeverRainsInCalifornia = iif(EventType =="Heavy Rain" and State =="CALIFORNIA", "it pours, man it pours", "") //if-then-else - else is left blank in this example
Jul 14 2022 03:34 AM
Jul 14 2022 03:42 AM
Jul 14 2022 04:11 AM