You might want to check the links in this thread. Most of them are links to this thread, they’re found below each post. There should still be something useful to be found in some of them. Especially this one:
and also the Haversine formula and for some use cases more general the Great-circle distance.
You haven’t given us much information about your problem, but a general outline could look like this:
- Cross Join your input tables/vectors (beware, table size blows up dramatically)
- calculate distance between points in each row (Haversine formula)
- for each target point, select shortest distance (Duplicate Row Filter on target point, using Min-distance as tiebreaker)
Let us know if you need any more help! 