试用软件

How to merge two excel files based on common column ?

8 次查看（过去 30 天）

显示更早的评论

Namrata Goswami 2020-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/650358-how-to-merge-two-excel-files-based-on-common-column

评论： Namrata Goswami 2020-11-18

采纳的回答： Ameer Hamza

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza 2020-11-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/650358-how-to-merge-two-excel-files-based-on-common-column#answer_546753

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.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Namrata Goswami 2020-11-18

Thank you. This helped!

请先登录，再进行评论。

更多回答（0 个）

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

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

标签

Community Treasure Hunt

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

Translated by

试用软件