Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Data Format - Conditional Logic

rcoolz1
5 - Atom

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?

 

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

@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
5 - Atom

Thank you for the heads up!

Labels