Distance between one point in one schema and all points in another schem
Distance between one point in one schema and all points in another schema
In this tip we are going to create a distance value between the CACI office postcode and Branch Customers. But this could be (not exclusively) between a postcode and all of the postcode sector centroids
Open a browse on postcodes
Find and select the postcode W14 8TS
Go to Set as base and choose Base03
Choose Yes
The distance expression is structured as follows
Distance(point1, point2, 3) where 3 is miles
Note: 3=Miles. If you want kilometers, type 1, and if you want metres, type 2
Open a browse on the Branch Customers
Add a column
Type in Distance(
Go through the link to Base03
Open the table and double click on the point column
Type a comma
Go on to the Branch Customer table and double click on the point column
Type a comma and then 3 and close the bracket
Distance({STD_BASE3}(MASTER.LOCATION) ,MASTER.POSTCODE_POINT ,3)
Click on Add, the column will be displayed with the distance, in this example the output will be in minutes
Extra Tip: If you save this browse and reset the Base to be a different Postcode and click refresh on the saved browse, new distances will display from the new Postcode.
Last updated