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.

Transpose multiple fields in alteryx

fbdsyd
5 - Atom

I'm trying to transpose the following:

A              |month   | balance

Sales       | 02        |  98732

Cost         | 01        |  65468

Expense  | 03        |  8543

Sales       | 01        |  98732

Cost         | 02        |  65468

Expense  | 02        |  8543

 

so that it ends up with:

month   |Sales       | Cost         |  Expense

01         | 98732     | 65468       |

02         | 98732     | 65468       | 8543

03         |                |                  | 8543

 

how do i make this transpose work in alteryx?

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi @fbdsyd,

 

Cross tab is a tool to use.

 

Emil_Kos_0-1605526115177.png

Please find attached a workflow that I have prepared.

 

If my post was helpful please mark as an answer! 

messi007
15 - Aurora
15 - Aurora

Hi @fbdsyd,

 

You can do that with Cross tab

 

messi007_0-1605529844571.png

 

Hope that helps !

 

Regards,

 

atcodedog05
22 - Nova
22 - Nova

Hi @fbdsyd 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1605531783076.png

Workflow:

atcodedog05_1-1605531802340.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Emil_Kos
17 - Castor
17 - Castor

Hi @fbdsyd,

 

If our solutions have been helpful please mark as a solution!

 

Good luck!

Labels