PDA

View Full Version : duplicate values



paulus
11-22-2005, 02:50 AM
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?

MrBarefoot
11-24-2005, 09:48 PM
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

paulus
11-25-2005, 06:32 AM
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.