title: How to efficiently compare two CSV files with differing columns
body: <p>I have two separate CSV files, one with columns <code>ABCD...</code> and one with columns <code>ABD...</code> and I need a way to compare the differences in the matching columns. </p>
  
  <p>I tried using Beyond Compare, but it assumes column ordering in the right matches the left so it doesn't work as expected. I have also tried using <code>Compare-Object</code> in PowerShell but it seems to only compare one column at a time and due to the large data set this would be a long process. 
  The current solution I'm using is to import both CSVs to a SQL table and compare them using RedGate tooling and then dropping the SQL tables, however this seems inefficient.</p>
  
  <p>Is there a better method for comparing such CSV files in Windows?</p>