# Calculating incremental closest distance in ArcGIS Network Analyst?

I have two sets of points:

• set "Destinations" has 417 entries(SmallList);
• set "Origins" has 15336 entries(BigList).

My goal is to do a calculation regarding driving distance, that will result in a table like follows:

• column A represents the list of points from set "Origins" using as name the assigned ID;
• column B represents the closest point from set "Destinations" using as name the assigned ID;
• column C tells the driving distance between "Origins"and the closest "Destinations";
• column D represents the 2nd closest point from the set "Destinations" using as name the assigned ID;
• column E tells the driving distance between "Origins" and second closest "Destinations";
• column F represents the 3rd closest point from the set "Destinations" using as name the assigned ID;
• column G tells the driving distance between "Origins" and third closest "Destinations".

Being somewhat familiar with NA, I did some reading as well and it seems that the OD matrix without using the line generator for better processing time, would be the best choice, but when trying it in Pro, I get some odd results.

So for the testing I have use 174 Origin points and 9 Destination points. Created the network dataset in ArcMap, loaded it into PRO and ran the OD matrix using the ND just created. For settings, I have not used any cutoffs and set destination number to 3. The results were odd, because even if I use as destination 3 or 9 or 7, I get 100 lines in total.

I am using Pro as main driver, but I have ArcMap background, so wont mind if someone can offer a solution in one or the other.

For the network data set I am using a dissolved version of the US Roads 2018 provided by TIGER.

Could somebody point me in the right direction on how to get this distances?

Bassically, for each "Origins" point I need the 3 closest "Destinations" points in driving distance.