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

How to transpose table

tl92
6 - Meteoroid

Hello everyone,

 

since I am a beginner, this is probably a very simple question - but searching for 'transpose table', 'rotate table', 'rows to columns' didn't yield any useful results for me.

 

So my question is: How can you rotate a table that the orientation is transposed?

E.g. if I have a table with 3 columns and many rows

 

A              |  1               | 9

B              |  2               | 8

C              |  3               | 7

D              |  4               | 6

E              |  5               | 5

F              |  6               | 4

...             |  ...               | ...

 

 

How can I turn it into:

 

A  |  B  |  C  |  D  |  E  |  F  |  ...

1  |  2  |  3  |  4  |  5  |  6  | ....

9  |  8  |  7  |  6  |  5  |  4  | ....

 

 

And vice versa?

 

I have tried to play around with crosstab and transpose - these didn't yield the desired results though.

For crosstab I wish there was the possibility to select multiple "Data fields".

 

4 REPLIES 4
tom_montpool
12 - Quasar

Welcome to Alteryx!

 

Sometimes a single tool doesn't do what you want, in this case, a transpose and a crosstab will generate the results you want.

 

 

cbridges
11 - Bolide

See attached. In this case, you need to use a transpose tool AND a crosstab tool. Confusing, I know. I'm with you that multiple data fields in crosstab would be very helpful.

@thizviz
cbridges
11 - Bolide

LOL - great minds think alike, though in my case 4 minutes slower :-)

@thizviz
CDunhill
8 - Asteroid

There ought to be a rotate table tool

Labels