title: How to merge two csv files with PowerShell
body: <p>I have two .CSV files that contain information about the employees from where I work. The first file (ActiveEmploye.csv) has approximately 70 different fields with 2500 entries. The other one (EmployeEmail.csv) has four fields (FirstName, LastName, Email, FullName) and 700 entries. Both files have the FullName field in common and it is the only thing I can use to compare each file. What I need to do is to add the Email address (from EmployeEmail.csv) to the corresponding employees in ActiveEmploye.csv. And, for those who don't have email address, the field can be left blank.</p>
  
  <p>I tried to use a Join-Object function I found on internet few days ago but the first csv files contain way too much fields for the function can handle.</p>
  
  <p>Any suggestions is highly appreciated!</p>