Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2016
    Posts
    4
    Provided Answers: 1

    Unanswered: Updating Tables via an upload where name fields may not match perfectly

    Basically I have a Database whereby I need to upload from csv inputs each week.
    The problem is that in my Database I have a "Name" field, however the update data comes from various sources and as such there will be differences in the way the names are spelt or maybe in different forename/surname order.

    I have in mind the Fuzzy Lookup or pwrVLookUp feature in Excel.

    Is there a way of Uploading the new Data and being able to overcome these differences or would it more efficient to put the effort into cleansing the data before upload?

    Would love to hear from anyone who has experience with this challenge.

    many thanks,
    Carl.

  2. #2
    Join Date
    Sep 2007
    Location
    Bangalore India
    Posts
    28
    Hi,

    Its can be done thru SP or scripts, because mysql dump the data checking the value exists or not.
    Not check the different so you can handle this one SP or scripts

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    consider using a matching algolrythm such as soundex double/triple metaphone

    another approach is to run a two stage process
    1) import the CSV into a holding table
    2) add what you can that does match, delete those rows from the holding table
    3) then get the users to resolve the issues and re submit (step 2).
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •