Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
Hi,
Here is a suggestion:
I hope this helps
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?
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.