Best way to Transpose & Cross Tab

[Hakimipous]

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! 

[AmeliaG]

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

[cmcclellan]

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 :) )

[Hakimipous]

@AmeliaG @cmcclellan 

Thanks for your reply! 

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

[Hakimipous]

@cmcclellan @AmeliaG 

Post has been edited with the input file !

[NickC · Accepted solution]

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

[Hakimipous]

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)