2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

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

Transpose like excel functionality

Shank
8 - Asteroid

Hi All,

 

I need to transpose data similarly to excel can some one help on this.

 

Many thanks for your help

 

Input

 

NameYearStdV1V2
A2018NORMYesYes
B2018NORMYesYes
C2018NORMYesYes
D2018NORMYesYes
E2018NORMYesYes
F2018NORMYesYes

 

Desired Output

 

NameABCDEF
Year201820182018201820182018
StdNORMNORMNORMNORMNORMNORM
V1YesYesYesYesYesYes
V2YesYesYesYesYesYes
6 REPLIES 6
BenMoss
ACE Emeritus
ACE Emeritus
You can so this in two steps with Alteryx.

First transpose your data. Your name field will be your key field and everything else should act as a data field.

This will give you three fields. Name, Name2 and Value.

Next, use the cross tab tool.

Name2 will be your group by field, Name will be your headers field and Value will be your value field.

Give this a try and let us need further help or if it brings you to a solution.

Ben
haroon_sa
10 - Fireball

Hey @Shank

 

Check out this solution. Hope it helps.

 

tr1.PNG

Present_guy
8 - Asteroid

A development possibility...... add a single tool or parameter for "Excel transpose"? Students find it frustrating to have a transpose tool that is unlike their familiar transpose tool.  

flying008
10 - Fireball

Hi, @Present_guy 

 

Just like your need function in gallery.

 

录制_2022_06_18_08_11_28_338.gif

 

Present_guy
8 - Asteroid

Thanks - can you please provide a url? I searched for and couldn't find this. And interestingly, there are MANY posts about this issue in the discussions and several very helpful work--around solutions. 

flying008
10 - Fireball

Hi, @Present_guy 

 

here you are.

 

https://community.alteryx.com/t5/Public-Community-Gallery/Transpose-Excel-style/ta-p/904150

 

Labels