title: How to write Kusto query to get results in one table?
body: <p>I have 2 KQL queries and I want to combine them in order to display two rows as one result. Not just result of first query, then result of second query: </p>
  
  <pre><code>R_CL
  | where isnotempty(SrcIP_s) 
  | project Message 
  | take 1;
  
  R_CL
  | where isempty(SrcIP_s) 
  | project Message 
  | take 1
  </code></pre>
  
  <p>See sample <em>R_L</em> below.I would like to see 2 rows as result, one with SrcIP_s not empty, and the second with SrcIP_s empty (in this case it will be always same one)</p>
  
  <pre><code>let R_CL = datatable ( SrcIP_s:string, Message:string)
  ["1.1.1.1" ,"one",
  "" ,"two",
  "2.2.2.2","three",
  "3.3.3.3","four"];
  R_CL
  | project SrcIP_s, Message
  </code></pre>