0 Replies Latest reply: Jul 25, 2018 3:54 AM by Vincent Bellanger RSS

    Partial matching between primary keys

    Vincent Bellanger

      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.

       

      NameYear
      Francis1995
      Denis1985
      Jean1975
      NameAge
      Francis Lalan22
      denis Rousseau39

       

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

      NameAgeYear
      Francis221995
      Denis391985
      Jean1975