Euclidean distance between centroids

Discussion created by conrad87 on Aug 24, 2013
Latest reply on Sep 11, 2013 by conorbarber_CedarPark
Ok here is another question for my mapping project:

I've got two Layers - "A" and "B". Each layer contains one type of polygons.

What I'm trying to do is to calculate the average euclidean distance between every single polygon (or centroid of every single polygon) of "A" with every centroid of all polygons of "B" (and note in table). - I've attached a graphic to visualize my task.

I've tried so far the "Calculate Distance Band from Neighbor Count" tool but it's looking randomly at neighbors and its count is limited to 9.999.

What do you think I should do?

edit: the calculation of the average distance is not mandatory.