7 Replies Latest reply: Mar 27, 2014 9:24 AM by sunil kumar RSS

    Function to match two items

    David Young

      HI All,


      I am not sure this can be done but wanted to throw it out and see if anyone can help:


      The Problem:  I have two tables with Vendor Information listed and the vendor is spelled slightly different in both tables.  Is there a way to do some match, fix, or anything else to correct the issue.  Here is an example of what I am talking about:


      Vendor Table 1



      Vendor Table 2



      In other words the Vendor name in both list is the same but spelled slightly different.  Is there any tricks out there.