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

Pivoting data to promote first row of data to headers (in original order)

Hello, 

 

Need a bit of help with pivoting data to create new headers. I think I've got the technique, but Alteryx reorders the headers into alphabetical order rather than the order they were originally in.

 

See the attached workflow - the numbers underneath the header show the order the headers should be in.

 

Secondly - best way of getting rid of underscores. I've previously used the formula function in the dynamic rename tool.

 

Thank you :)

Lucy

Quasar

Hey @LucyDickinson!

 

Try out this macro we use here at our company which transposes like Excel does. After that, I used a Multi-Field Formula tool to get rid of the underscores. Lastly, I used a Dynamic Rename tool to take the field names from the first row of data.

 

Hope this helps!

 

P.S. I believe @patrick_digan deserves credit for creating this awesome tool.

This is amazing! Thank you @BarnesK and @patrick_digan :) 

Labels