1 2 Previous Next 16 Replies Latest reply on Sep 30, 2016 10:13 PM by FabriceNordmann

    Lookups are not matching

    yomango

      Hello everyone. I am running into a problem and can't figure out what is happening: I am scrapping web sites into several Excel files; after that, I am bringing into a two table FM fie what I have scrapped. In one table (company table) I bring Company name, telephones, contacts, etc, and on the other table(import url) I bring company name and URL. Then I do a relookup to match company names and to update  the company table url field. My problem is that in many occasions the company name in one table has leading or trailing spaces. So, I trimmed the company names on both tables before importing, but still  some same company names on both tables show no match. Is tehre a way to tell FM not to import any text format, just plain text? And one more thing that baffles me, when I copy paste from one table to the other to "force a match" most of the time it works but not all the time.

       

      I 'll appreciate a hint. Thank you

        1 2 Previous Next