How to merge two excel files based on common column ?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Namrata Goswami
le 17 Nov 2020
Commenté : Namrata Goswami
le 18 Nov 2020
I have two excel sheets that I need to combine into one.
For example
File1:
ID Name
1 abc
2 xyz
3 mno
File2:
ID Job
1 teacher
2 singer
3 driver
Once I import these two excel files, I want to combine them into one, based on the common column "ID"
Output file:
ID Name Job
1 abc teacher
2 xyz singer
3 mno driver
0 commentaires
Réponse acceptée
Ameer Hamza
le 17 Nov 2020
See innerjoin(): https://www.mathworks.com/help/matlab/ref/innerjoin.html or outerjoin(): https://www.mathworks.com/help/matlab/ref/outerjoin.html. Use whichever is suited for your purpose.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!