Data Format - Conditional Logic

Question

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

Here is a sample of my data set:

OutBoundInBound DALHOUMDWFFL

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:

OutBoundInBound DALDALHOUHOUMDWMDWFFLFFL

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

CharlieS · Accepted Answer

@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.