Iterative Macro to sort Route

[outwork]

I have a dataset with start and end locations in 2 seperate columns. The data is shuffled. The end location is the new start location in another row. How can I sort this to get an output like this

Before

Barcelona -> Paris

Madrid ->New York

Paris -> Madrid

After:

Barcelona -> Paris

Paris -> Madrid

Madrid ->New York

...

[LordNeilLord · Accepted solution]

Hey @outwork

How about this?

I added some functionality to find the first journey (based on the first unique start location) but you can ditch that if you don't need it.

I've also set the number of iterations to 10 which you can change depending on how many legs you might need.

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[outwork]

exactly what I was looking for.  Thanks a lot LordNeilLord! Higly appreciated. Can you recommend further sources to learn macros and worklows beside simply building them?

[annaprosvetova]

Thank you for posting this solution, Neil! Was trying to solve a similar problem, and your workflow is just perfect!

[handa997]

.

[WCH]

Hi Neil,

Are we still able to find that "Engine.IterationNumber" function in the formula tool? Thanks.

[Luke_C]

@WCH You can, but only if the workflow is an iterative macro:

[WCH]

just figured it out 1 sec ago. Thanks  Luc!!