How to merge two excel files based on common column ?
조회 수: 8 (최근 30일)
이전 댓글 표시
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
채택된 답변
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!