Im trying to calculate a batch of data with a pupil unique identifier, their home postcode and their adoption placement postcode.
I would like to find the distance between the home and the placement of the pupil. I do have RouteFinder but only a small road network so I'm happy to just get a straight line distance measurement.
I have tried creating two sperate tables with the geocoded postcodes, one for home postcodes with the unique pupil ID and one with their placement postcodes with the ID.
Has the distance calculator got a capability of just calculating the home postcode point to the placement postcode point where the identifiers match.
I know i can get every possible combination and then filter it out in Excel using a formula however i can only do this for small batches of info.
Can anyone let me know if there is a better way to do this with a large data set?