How to access a single result of a multi result query in KQL

user_18910 0
Viewed 127

Given the example query:

StormEvents | evaluate funnel_sequence(EpisodeId, StartTime, datetime(2007-01-01), datetime(2008-01-01), 1d,365d, EventType, dynamic(['Tornado', 'Hail']))

Which returns 3 table results, PrevNext, Prev and Next, how do I access in KQL only one of the results? I'm interested in something like:

let PrevNext, Prev, Next = StormEvents | funnel_sequence(...);
Next | where ...
kql azure-data-explorer
1 Answers

There's no way to do this in a single KQL query, unfortunately. The follow up text after the funnel_sequence plugin receives only the first table (PrevNext) as input. If it helps, you can find samples here of how to read the different tables programmatically.

user_103721530
Related