Alteryx designer Discussions

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

How to transpose table

Highlighted
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".

 

Highlighted
ACE Emeritus
ACE Emeritus

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.

 

 

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
Highlighted
Bolide

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

@thizviz
Labels