Compare two files

How to compare two files in PS.

Which type of file and in which scenario, you want to compare?

I have two excel files, one is newly created file and another is old file with same fields, I want to compare this newly created file with old file and update new details in old file.

If headers are same then, it has one unique column in it, So

  1. Take two input excel steps for old and new file.
  2. Sort steps for sorting the unique column.
  3. After sorting with the help of merge join, get matching columns and update remaining data in new file.
1 Like

Thanks Bhagyashri.