community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Data Format - Conditional Logic

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