Partial matching between primary keys

Anonymous — Wed, 25 Jul 2018 07:54:47 GMT

Greetings,

I have 2 tables and i want to compare their data in a sheet but their primary keys is their name but in the other table the name is longer and sometime does not contain upper case.

Name	Year
Francis	1995
Denis	1985
Jean	1975

Name	Age
Francis Lalan	22
denis Rousseau	39

If i want to have a table like this, is there any partial matching way to do it ?

Name	Age	Year
Francis	22	1995
Denis	39	1985
Jean		1975

topic Partial matching between primary keys in Visualization and Usability

Partial matching between primary keys