Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Repetition in Columns to Rows

Highlighted
6 - Meteoroid

Hello,

 

I have flight data that are categorized in column B "Routing", I would like to have this information going across horizontally as Flight In , Time, Route then Flight Out, Time, Route, and then Flight In 2, etc.

 

In addition, after the the data have been transposed horizontally, any repetitions of rows after the first row can be deleted. As well as, one person can have up to 15 occurrences of fly in and fly out, so how do I concise it and not have an output that have so many columns? 

 

Input

cchueh_0-1592594657187.png

 

Preferred Output:

 

cchueh_1-1592595004464.png

 

My current workflow, however's it's messy and not as concise as I would like it to be:

 

cchueh_2-1592595199291.png

 

cchueh_3-1592595214839.png

 

Highlighted
12 - Quasar

Hi, @cchueh 

 

Slightly different result presentation (due to limitations seeding field values into field name).

Still, try this.

 

Please mark as a solution if acceptable + like if helpful.

 

str_name_key, Date, Dir (in or out), Time, Route

RobertOdera_0-1592617055043.png

 

The workflow is attached.

Cheers!

 

 

Highlighted
Alteryx Certified Partner

Hi @cchueh - I took a little bit different approach than @RobertOdera but I think it will still work. One of the great things about Alteryx is the ability to solve the same problem in many different ways. 

 

flights.png

 

 

Highlighted
12 - Quasar

You're most welcome, @cchueh !

Cheers.

Labels