How to merge two excel files based on common column ?

9 次查看（过去 30 天）
Namrata Goswami
Namrata Goswami 2020-11-17
评论： Namrata Goswami 2020-11-18
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

请先登录，再回答此问题。

采纳的回答

Ameer Hamza
Ameer Hamza 2020-11-17
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by