Mapping age/date of birth of IDs in one excel to the same IDs in another

2 次查看（过去 30 天）

Vijay 2020-9-14

评论： Vijay 2020-9-14

I have two excel files:

one file with several IDs (no repeats) with their age/DOB information.

Another file with the same IDs (with and without repeats) without age/DOB information.

Two of such files are attached for a reference.

How can I incorporate the age information from age.xlsx into the NoAge.xlsx mapping the IDs?

Thanks in advance.

Image Analyst 2020-9-14

Maybe readtable() and join them with innerjoin(), outerjoin() or join()?

Vijay 2020-9-14

Awesome! It works.

Thank you so much for your time and help.

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

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

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

Translated by