Distance Tool - Tour Dates

[jesuisbo]

Hi everyone,

I'm hoping to get your help with the following; 

My dataset contains tour dates for multiple artists and what cities they've visited. I want to calculated the distance travelled of a particular artist. I'm stuck however since we're talking about more than 2 destinations. Is there a way to calculate the distance between multiple citites with the distance tool (or anything else)? 

Please find a snippet of the dataset below. I do know that you need to have transpose the rows to columns still. 

Tour sequence is the order in which the artist travels. 

Any help would be much appreciated! 

Thank you

Bo

[BenMoss · Accepted solution]

There's quite a few methods to achieve this.

You could use the polybuild to built a line spatial object using the sequence field for each artist. You can then use the spatial info tool to calculate the total distance.

Alternatively you could use the multirow formula tool to calculate the distance between the active row and the row beneath, and then use the summerize tool to get your total distance.

Example workflow attached with both solutions.

Note, the latitudes and longitudes are completely made up. 

Ben

[jesuisbo]

Thank you Ben - this works perfectly!