CODEWITHSUNDEEP
azure-data-explorerkql
adams
adams

Reputation: 606

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

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 ...

Upvotes: 1

Views: 576

Answers (1)

yifats
yifats

Reputation: 2744

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.

Upvotes: 1

Related Questions