Find Distance b/t Locations on Different Rows

[FarSideFeb]

Hello,

Is there a way to find the geographical distance in miles between addresses which are on different rows of data?
For example my dataset would look similar to the below and I would want to know the different in miles between the loading and shipping location for an order:

Order#    Status   Address
123            Load     45 Main St. Akron, OH
123            Ship      38 Red St.  Trip, UT
7789          Load    29 Bird St.  Boise, ID
7789          Ship     51 Main St. Tahoe, CA

---

Operating system used: Windows

---

Operating system used: Windows

[Manuel]

Hi,

Here is a suggestion:

1. Your dataset needs to have column to order from. Perhaps you already have a timestamp. Otherwise, in a Prepare recipe, prefix Load/Ship with 1-,2- 
2. Use the Window recipe, partitioned by order number and sorted by your order column, to add the geopoint from the previous row to the current row. 
3. In a Prepare recipe, use the "compute distance between geopoints" processor

I hope this helps

[FarSideFeb]

Thank you for the suggestions Manuel!
On the "Window" recipe, in the "Aggregations" section, how do I add the geopoint from the previous row to the current row?

[Manuel]

Hi,

In the Window definition, define the frame to pick one preceding row.

In the Aggregations, use Last to pick the geopoint from the preceding row.

I hope this helps.