Clay Icon

Finding Closest Companies Between Two Tables Using Locations

·
·

Wondering if anyone has a solution / workaround to something im running into;

  • I have locations (long/lat) of companies in table A

  • I have locations (long/lat) of other companies in table B

  • For each row in table B, I want to lookup to table A to find the closest(s) in proximity company(s).

  • I am sure Claygent could do the math -- im stuck on how to do the lookup between tables to find the closest option(s)