Data Format - Conditional Logic

[rcoolz1]

I am trying to find a way to format data faster in Alteryx with airline codes.

Here is a sample of my data set:

OutBound	InBound
	DAL
HOU	MDW
FFL

I need to be able to make the inbound stations the outbound stations to show a complete flight path. I basically need the data to end of looking like this:

OutBound	InBound
	DAL
DAL	HOU
HOU	MDW
MDW	FFL
FFL

I have a data set of over 10,000 records. What would be the fastest way in Alteryx to do this?

[CharlieS · Accepted solution]

@rcoolz1

I assume that your data will also have records for DAL > HOU and MDW > FFL? In that case, I would suggest an iterative macro that solves the next sequential flight leg one at a time.

I would normally post a solution, but this is very similar to an examination question from Alteryx and I don't want to spoil the fun for anyone. I hope this gets you on the right track. 

[rcoolz1]

Thank you for the heads up!