ONE QUERY OUTPUT AS INPUT TO ANOTHER QUERY

c.mavi01 0 Reputation points
2023-11-25T05:32:07.5366667+00:00

HI,

I want to write three or more queries where-in one query output is served as input two next query and subsequently it should go to some around 3 or more levels.

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
333 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sander van de Velde 29,281 Reputation points MVP
    2023-11-25T13:07:29.99+00:00

    Hello @c.mavi01 ,

    welcome to this moderated Azure community forum.

    The stream analytics QL editor gives an error if you want to reuse the same output for a second query.

    If you want to write the outcome of three separate queries into the same output, you need to union them together via the With clause.

    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

    0 comments