Hello! I’m trying to fully understand your question, but I’m a bit unclear on a few points. Specifically, I’m not sure where the Tile_Num in the top table is coming from, as it doesn’t seem to represent distance.
Also, when you mention taking the three shortest distances, are you referring to the sum of the distances, the closest store, or the sum of the top 3 stores? It’s not immediately clear how Tile_Num relates to these concepts.
Lastly, you mentioned wanting to take the 4 nearest employees, but I noticed there are only 3 listed in the second table under Tile_Num, and New ID doesn’t exceed 3.
It might be helpful if the field names were a bit more descriptive, so we can better understand the purpose of Tile_Num and New ID in the two tables.
All that said, if I assume...
- Tile_Num is given in table 1
- New ID in table 1 = Rank of Employees after sorting for distance (which I think is what Tile_Num represents)
- In table 2, you want to top 3 employees and 3 nearest stores.
- In table 2, Tile_Num = 1 for the top 3 employees.
- In table 2, New ID is the rank of the employee within the Tile_Num based on the previous Tile_Num from table 1.
...then I can replicate your results with the attached workflow. Let me know if you have questions or can provide any more clarification about your goal. Hope this helps!
