Challenge #6: Spatial Route

[dharini]

Solution attached

[chris_ramsay_dup_425]

Hi,

Please find my solution below

Thanks,

Chris

[DriveMyData]

Spoiler

[MarMu]

Not the most difficult challenge, but got to play around with the Spatial-tools :) cool suite!

Spoiler

[Inactive User]

Here's my solution!

Thanks

[mceleavey]

Ah, The Travelling Salesman problem. I just had to do this with the added complication of multiple timeslots within a given day, and that baked my noodle.

This is relatively straightforward, and I've probably done this in the same way as most.

Spoiler

I began by splitting the stream and off-setting the row by subtracting 1 from the row order and joining back together, thus displaying the start and end point on each row.
I then split the steam again, one to determine distance travelled and one to plot the route using a polyline build. I then smooshed it back together and sorted by distance descending. 



ps - "Smooshed" is a word. Shut up.

[jlaverne]

Great challenge.

[tammybrown_tds]

I was not able to open the challenge start file, as it was apparently created in a new version of Alteryx.  I am on 11.3. Does anyone have a version of the challenge file that works on 11.3?

[DanM]

@tammybrown_tds,

Are you getting an error opening the yxmd file? This Challenge was done in a much older version of Alteryx than 11.3.

DanM

[tammybrown_tds]

Yes.  Screen shot shown below.