community
cancel
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?

LEARN MORE
SOLVED

Data Format - Conditional Logic

Highlighted
Alteryx Certified Partner

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
 DAL
HOUMDW
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:

 

OutBoundInBound
 DAL
DALHOU
HOUMDW
MDWFFL
FFL 

 

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

 

Alteryx Certified Partner

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

Alteryx Certified Partner

Thank you for the heads up!

Labels