title: How can I get rid of unnecessary columns in powershell query output
body: <p>I have this code below, when I run it the output file has additional columns like Comment, RowError, RowState, Table, ItemArray,    HasErrors </p>
  
  <pre><code>$dataSet.Tables | Select-Object -Expand Rows |
  ConvertTo-HTML -head $a –body $body |
  Out-File $OutputFile
  </code></pre>
  
  <p>I want to get rid of these columns but dont know how to. I have checked other online resources but couldn't help. Is there anything am doing wrong here??</p>