Forum Discussion

Dihros's avatar
Dihros
Frequent Visitor
6 years ago

Equitable distribution by shorter distance - Geolocation

Appreciable all I require your support for the following, I need to assign clients to the closest manager by location, but these assignments should be distributed evenly, if the closest manager is a...
Need Help
Dihros's avatar
Dihros
Frequent Visitor
5 years ago

if i understand well i had done the change in the code already 

 

 

Also my test data set has only 9 manager in total

 

What i mean is :

this is the result of your code using my test data set

 

 

Checking the data, I found that some IDs are duplicated and which I mark in red,

 

 

Taking for example the ID:3100615, it is located in row 287 and 1673 with manager 7 and 8.

 

 

I also checked your Table but it doesn't have duplicated. im no sure what's happening

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

mmhhhh ... as far as I remember the code makes use of the list of customer ids only to associates the various managers. Each customer id is only treated once, and the list is not manipulated.

Have you checked that the duplicates are not already in your original list?

Could you just provide the list of IDs you use?