2

I have a csv file named master.csv, which has the following columns

link, name

And another csv file called details.csv, which has the following columns

link, name, price, desc

I want to match master.csv against details.csv and delete the rows from master.csv which already have details in details.csv. link column is the unique column that matches both.

1 Answer 1

5

In Excel you can do like this, the manual way:

  1. Open details.csv.
  2. Open master.csv, copy all content and paste it below the last line in details.csv.
  3. Close master.csv.
  4. Select Remove Duplicates, mark only Column A and press OK. Now the duplicate rows should be removed from the lower part of the document (originating from master.csv).
  5. Remove the rows in the upper part of the document, that originated from details.csv.
  6. Save the file as master.csv.

If you have some requirements that it should be done programmatically, in another program or about the output of the operation, please provide that information.

2
  • 1
    This should work. As of now, I have no need to do the same programmatically.
    – esafwan
    Commented Feb 19, 2018 at 11:05
  • 2
    Great to hear and I'm glad I could help! Actually it's my first answer that gets accepted :-)
    – PatrikN
    Commented Feb 19, 2018 at 20:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .