Alteryx Designer Discussions

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

Help crosstab and transpose

5 - Atom

Hello,

 

I have been trying without success to transform the input into the output that I attach, with crosstab and transpose operators without success if someone knows a way to solve it please let me know, I am frustrated 😞

Alteryx Partner

This should work for you 🙂

 

2018-05-28 07_37_26-Alteryx Designer x64 - samplect.yxmd.png

13 - Pulsar

Here is the solution for your case. Used select tool to remove unwanted columns.  Transpose and crosstab tools will help you to get desired results. 

 

WorkflowWorkflowResultsResults

5 - Atom
 
Labels