I have two separate files containing information on clients that I would like to merge into one. The first file contains global information, the second is for options.
Basically, every client has an entry in the first file, whereas only some have an entry in the second file.
What I'm aiming to do is to merge the second file into the first (complete) one, with (if possible) no duplicate columns. I've tried pasting and cat, but with no success...
Example :
complete.csv :
Number Name Surname Price Town
2 Alpha Beta 10.0 Blob
1 Gamma Delta 13.0 Upsy
options.csv :
Number Name Surname Op_Price Option
1 Alpha Beta 65.0 Yawn
I would like to get something like this :
result.csv :
Number Name Surname Price Town Op_Price Option
2 Alpha Beta 10.0 Blob 65.0 Yawn
1 Gamma Delta 13.0 Upsy
Could you point me in a direction ?
Cheers
cat
and then remove duplicate entries. that will ease some overhead of handling two file logic. to remove duplicate entries see stackoverflow.com/questions/1444406/…