topic Transpose multiple fields in alteryx in Alteryx Designer Desktop Discussions

Transpose multiple fields in alteryx

fbdsyd — Mon, 16 Nov 2020 11:25:50 GMT

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?

Emil_Kos — Mon, 16 Nov 2020 11:29:09 GMT

Cross tab is a tool to use.

Please find attached a workflow that I have prepared.

If my post was helpful please mark as an answer!

messi007 — Mon, 16 Nov 2020 12:31:21 GMT

You can do that with Cross tab

Hope that helps !

Regards,

atcodedog05 — Mon, 16 Nov 2020 13:03:37 GMT

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

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

Emil_Kos — Mon, 16 Nov 2020 22:05:06 GMT

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

Good luck!