1 Reply Latest reply on May 12, 2017 4:13 AM by sesha.peram

    Disambiguate names that are in two different columns by linking the columns?

    Sophie Lauren

      Hello,

       

      I have a table with two columns containing names (ex: Panagidi/Kyriaki and Panagidi/K).

      Screen Shot 2017-05-10 at 8.37.01 AM.png

      How can I link the two versions of the name so that they are considered one?

      Note, I have other tables (like affiliations) that are linked to either one or the other version of the name

       

      If it is not possible to link the two versions of the name, how should I reformat my table so that I can do what I want with it (for example I want a Top 20 Authors where Panagidi doesn't appear with the first names Kyriaki and K).