title: Powershell Compare column in csv
body: <p>i'm trying to compare two csv files. And i want to check if there are objects that have the same name but different content but I don't know how i can do it. Can you help me please.</p>
  
  <pre><code>$File1 = Import-Csv -Path "C:\Users\PM\Desktop\Migration\file1.csv"
  $File2 = Import-Csv -Path "C:\Users\PM\Desktop\Migration\file2.csv"
  $Tot_File = $File1 + $File2
  Foreach($file in $Tot_File)
  {
     $ident = $file.nom +  $User.prenom + $address.address
     Write-Host $file.Name -ForegroundColor White
     Write-Host $file.LastName -ForegroundColor DarkCyan
     Write-Host $file.Address -ForegroundColor DarkYellow
  }
  </code></pre>
  
  <p>In output I have objects in duplicate. At the level of names I don't want the double.</p>