title: Compare 2 csv files and replace updated values
body: <p>I have 2 csv files and I'm looking for a way to compare them using a specific column, and once a match is found I need to take the value of another column from the matched row and put it in the corresponding column of the other record.</p>
  
  <p>I'll try to explain a little bit more.</p>
  
  <p>One csv has <code>product_id,product_name,brand_name,price</code>
  the other has <code>product_id,product_category,product_name,brand_name,price</code></p>
  
  <p>I need to compare the 2 files by finding the rows that have a matching <code>product_id</code> value, and once found I need to take the <code>price</code> value from file 1 and put it to the matched record's <code>price</code> in file 2.</p>
  
  <p>After extensive research I've come to the conclusion that this maybe achievable with powershell. </p>
  
  <p>Does anyone have any ideas about how I could do that? Thank you for your time.</p>