How to flatten records / loop over records

I have been struggling with a "simple" task, but I simply cannot get my head around it, on how to solve this using Alteryx.

What I am trying to do, is kind of a flattening a kind of hierarchy, by which there is many examples of here, but this is bit simpler.

I have a set of data with travels, start point and end point, like this, but in no particular order

2018-08-28 23_49_24-Alteryx Designer x64 - travels.yxmd.png

What I am trying to accomplish is something like this

2018-08-28 23_49_55-Alteryx Designer x64 - travels.yxmd.png

I have tried different approaches, joining on end point to start point, and also the Multi-Row formula, but so far I have not crack this nut, and would like to know how to do such a recursive lookup to do this.

Br
/Verakso

travels.yxmd

Help

Join

Accepted answers

unknown

Answer attached. Used an iterative macro to do this.

travels.yxzp

All comments

unknown

Answer attached. Used an iterative macro to do this.

travels.yxzp

Verakso

Hi Ryan

I have accepted you solution since it does work, but my head is still spinning,

So I have learned something new, iterative macros. I had to read up on that and see a few training videos, but I do not think I have completely understood how it is solved anyway.

So the first part I seem to get 2018-08-29 21_29_27-toast.png

It is the macro I am trying to get a grasp at 2018-08-29 21_31_47-toast.png

I kind a get the two text inputs, the join and the formula, but then I am lost.

What is the I Output doing, and how does the iteration actual work?

When I have looked at other examples, there seems to be some kind of loop in either the macro, or in the workflow surrounding the macro.
Kind of what I would have expected with the outcome of I Output macro output.

So yes it works, but I have not quite figures out why.

//Verakso

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167