union all in azure data explorer

ADX 156 Reputation points
2021-11-05T08:58:03.71+00:00

Hi Team,

I have a data from two queries:

let query1=view()
{
let source1=(a|project col1,col2);
source1
};

let query2=view()
{
let source2=(b|project col1,col2);
source1
};

and the query1 results set data is like 1,hyd
and the query2 results set data is like 2,chennai

i want to perform the union all operation to get the data from both the queries results

1,hyd
2,chennai like this

Can someone help on this.

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
525 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee
    2021-11-05T15:23:29.063+00:00

    Hi @ADX ,

    Thank you for posting your query in Microsoft Q&A Platform.

    Union operator helps to achieve your case.

    Kindly check below link to know about Union operator in Azure data explorer.
    https://video2.skills-academy.com/en-us/azure/data-explorer/kusto/query/unionoperator?pivots=azuredataexplorer

    Please let us know how it goes or if any further queries.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.