Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Best way to Transpose & Cross Tab

Highlighted
Alteryx Certified Partner

Hello,

 

I'm posting here because I had to transform some data into a specific layout. Even if I managed to do it, I'm quite sure there is a way better way than then one I used to reach the final result I wanted (there always is with Alteryx! ). 

here is the output (transformed for data protection), the workflow and the final result I had to reach.

 

Could be nice if anyone could point me out a better idea on how to proceed to avoid that long splitting I did.

 

Thanks! 

Highlighted
Alteryx
Alteryx

Hi @Hakimipous

 

I'd be happy to help you. Can you please share the input file so that I can show you another way to build the process?

 

Thanks!

 

Amelia

Highlighted
Alteryx Partner

Maybe I'm missing something, but why not rename all the columns you require in the first Select ?

 

Supplying the original "cisco" file would be great though.  Just dummy up the data so that the file format is the same as your real data, but the numbers are rubbish (eg your Gross Salary can be 1 or 999999999, that doesn't matter at all :) )

Highlighted
Alteryx Certified Partner

@AmeliaG @cmcclellan 

 

Thanks for your reply! 

Looks like I did a wrong manipulation, I'll upload the correct file tomorrow morning! 

Highlighted
Alteryx Certified Partner

@cmcclellan @AmeliaG 

 

Post has been edited with the input file !

Highlighted
Alteryx
Alteryx

Hello,

 

If you click on the transpose tool and open the example there is a good example of using the transpose and cross tab in conjunction.   

 

See attached the my solution on Version 11.7.

 

Thanks,

Nick

Highlighted
Alteryx Certified Partner

Ok indeed that's pretty great. I did try something very similar without grouping by names. I yet have to spend more time on these tools as they can be real time saver in my case

 

Thanks again x) 

Labels