This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
In Excel, you can select a table of data and "Paste Transpose". This feature then pastes the data, but pivots the paste on the X and Y axis. Neither "Transpose" nor "Crosstab" tools are capable of this function presently (trust me, I've tried every combination possible with either tool or both in conjuction), and it is sometimes necessary to perform a simple pivot of the data on the axis.
I have had to work around this to manipulate my data into a pivoted form on several occassions, and it is quite a painstaking process. Other times, I have simply output my data into excel, performed the function, and re-uploaded the pivoted dataset downstream. It would be fantastic to have a simple tool that would perform this basic function, and nothing else.
If Excel can do it, Alteryx should be able to do it!!
Hmm... that's very cool. I am not a R coder, though I know how to copy/paste into an R tool. I tried that, and it errored out on me: Error: unexpected symbol in "df <- read.Alteryx("#1", mode="data.frame") write.Alteryx".
Any thoughts on what I'm doing wrong? I'd love to make a macro for myself using this code if I can get it ironed out. That'd be awesome.
That was the issue (sorry, total rookie at R here). Thanks for pointing that out to me. That's a great solution for integer-based data. Looks like I have two great solutions in my back pocket for this now!