LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Matching Data from Two Sources

    Employee
    Posted 12-16-2015 12:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ericbrazis

    I'm trying to match data from two sources; however, one source includes commas in the referenced field and the other doesn't. The names are the same between the two (ABC Company Inc. vs ABC Company, Inc.), but there is the comma separation in the name. What is the easiet way around this issue?


  • 2.  RE: Matching Data from Two Sources

    Employee
    Posted 12-16-2015 13:48

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    Two things you could do that are easy:
    1. Remove all non-alphanumeric characters.
    2. Make everything uppercase so Abc matches ABC.

    You may also want to use the Fuzzy Join/X-Ref nodes. The Levenshtein Distance algorithm allows two strings to match if they are within 'n' edits of another.
    Attachments:
    matching.brg