Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.

Travel itinerary sequence

I finished my approach off. Takes about 1 minute to run on mine.


It produces every possible path. I think there are 10,524 in the data set you gave.


The first macro as before collapses cases down (this takes 161 iterations).


Next, it walks back from the trip with no destination.

This second iterative macro works out each possible join.


Finally it builds out all the paths in full (10mm rows) as well as picking the first as well.



@jdunkerley79 this is so cool! Thank you so much for that. I see that it produces 10K scenarios, what Im gonna do now is to select the one where the total direct distance between the points will be the smallest. 

Again, hard assumption, but without additional inputs I would just use common sense I guess. 


Thanks everyone again! You guys are great!