title: Using both 'distinct' and 'project'
body: <p>In Azure Data Explorer, I am trying to use both the 'project' and 'distinct' keywords. 
  The table records have 3 fields I want to use the 'project' on: </p>
  
  <ol>
  <li>CowName</li>
  <li>CowType</li>
  <li>CowNum</li>
  <li>CowLabel</li>
  </ol>
  
  <p>But there are many other fields in the table such as Date, Measurement, etc, that I do not want to return. </p>
  
  <pre><code>Cows
  | project CowName, CowType, CowNum, CowLabel
  </code></pre>
  
  <p>However, I want to avoid duplicate records of CowName and CowNum, so I included </p>
  
  <pre><code>Cows
  | project CowName, CowType, CowNum, CowLabel
  | distinct CowName, CowNum
  </code></pre>
  
  <p>But when I do this, the only columns that are returned are CowName and CowNum. I am now missing CowType and CowLabel entirely. </p>
  
  <p>Is there a way to use both 'project' and 'distinct' without them interfering with each other?
  Is there a different approach I should take? </p>