Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

duplicate values

This is a discussion on duplicate values within the MapPoint Desktop Discussion forums, part of the Map Forums category; Ive made a Excel sheet with a lot of customers. with all the information required, and also added a column ...

  1. #1
    paulus is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    7

    duplicate values

    Ive made a Excel sheet with a lot of customers. with all the information required, and also added a column with the sales managers name of that customer( 4 sales managers)


    then I made 4 separate tabs within the sheet, where I have the clients specified by sales manager, using a excel formula.

    problem is that the original sheet looks like this(example:

    name.......zipcode.......sales manager
    a.............1234..............A
    b.............1235..............B
    c.............1235..............C
    d............ 3456..............A
    e.............3311..............B
    f..............3456..............C
    g.............6665..............A

    so on the sheet of sales manager A only his clients are shown, and the sheet looks like this

    name.......zipcode.......sales manager
    a.............1234..............A


    d............ 3456..............A



    g.............6665..............A


    I used th link data wizard to load the clienst of sales manager A on the map, this without problems.

    however when I try to update I get an error: the data source contains duplicate values within the primary key column, resolve the duplicate values, or link this data agian.

    I think this is because on the sheet with the infomatiion there are some empty cells between the records who needs to be linked



    someone has a solution?

  2. #2
    MrBarefoot is offline Junior Member White Belt
    Join Date
    Sep 2004
    Posts
    3
    I am not a MapPoint expert, so my advice may not be 100% correct.

    I am pretty sure that every row in your data file must have a unique ID column, just like a table in a database. If you don't have a unique ID or there are duplicates then MapPoint can't tell individual records apart and it doesn't like that.

    Just from reading your post, I think a database rather then a spreadsheet is a better choice for your data situation.

    If you can't do a database then perhaps you can build a column with an incrementing number for each row that doesn't repeat anywhere in the worksheet. Use that column as your "primary key", but that is bad form and won't work long term or with large amounts of data.

    Good Luck

  3. #3
    paulus is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    7
    thank you, but I'm sure that my primary key column doesn't contain duplicate values, I've checked that Myself, but because there are a lot empty cells between some values mappoint may see those as duplicate

    However, due to the error, mappoint does update the sheet.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Values
    By virgilar in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-17-2005, 02:39 PM
  2. Calculate New Long And Lat values.
    By jburgess in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-18-2004, 01:57 PM
  3. Values instead of pushpins
    By jojooboo in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-17-2004, 02:58 PM
  4. What is the smallest values that you put when using AddShape
    By Alex Chow in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-09-2003, 05:52 PM
  5. duplicate locations in one city
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-28-2003, 11:05 AM

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
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36