Read more about Data Workbench’s End-of-life announcement.

In mathematics, the haversine formula is an equation that gives circle distances between two points on a sphere identified from their longitudes and latitudes.

Like the formula, the Haversine transform requires two sets of Latitude and Longitude settings, using these four inputs to calculate the true distance across the Earth between two locations.

This distance can be represented as miles or kilometers by changing the “In Kilometers” flag from false to true.

Parameter Description Default
Name Descriptive name of the transformation. You can enter any name here.
Comments Optional. Notes about the transformation.
Condition The conditions under which this transformation is applied.
Latitude 1 Field The latitude of the point 1.
Latitude 2 Field The latitude of the point 2.
Longitude 1 Field The longitude of the point 1.
Longitude 2 Field The longitude of the point 2.
Output Once calculated, the Output field contains distances between the points designated as elements in a Dimension.

As an example, if you code in a latitude and longitude of their store as Lat1, Lon1 and use an IP lookup lat and long for their customers, then distances to a store most customers buy from or come from can be determined.


If you want to identify distances for other locations, then each individual location must have its own set of lat and lon fields.

On this page