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

Hi

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.

Answer 1

[Image Analyst]

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

[Vijay]

Awesome! It works.

Thank you so much for your time and help.