Howdy,
I've built a workflow that creates the output you can see in the "Current Structure" file. What I'm trying to do is get to the "Desired Structure" I've manually created.
In the transpose example, it shows a combination of transpose and cross tab tools being chained together to get to the desired output. I assume that been the transformation tools and possible a multi-row formula this can be done but I'm pretty new to Alteryx and I'm drawing a blank. I'm pretty new to Alteryx, previously I would have used formulas in excel to manage this.
Any help would be much appreciated!
-Luke
Solved! Go to Solution.
Works perfect and I just learned a bunch.
This is why I love Alteryx and the Alteryx community, thank you!
-Luke
After moving further along in the analysis I realized I made a mistake in my request. I actually need a solution that looks like this...
Class | A | B | C | D |
0 | 28 | 0 | 81 | 0 |
0.1 | 27 | 46 | 35 | 1 |
0.2 | 24 | 62 | 19 | 4 |
0.3 | 20 | 66 | 15 | 8 |
0.4 | 20 | 73 | 8 | 8 |
0.5 | 17 | 77 | 4 | 11 |
0.6 | 15 | 80 | 1 | 13 |
0.7 | 14 | 81 | 0 | 14 |
0.8 | 12 | 81 | 0 | 16 |
0.9 | 8 | 81 | 0 | 20 |
1 | 0 | 81 | 0 | 28 |
Not like this...
Class | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1 |
A | 28 | 27 | 24 | 20 | 20 | 17 | 15 | 14 | 12 | 8 | 0 |
B | 0 | 46 | 62 | 66 | 73 | 77 | 80 | 81 | 81 | 81 | 81 |
C | 81 | 35 | 19 | 15 | 8 | 4 | 1 | 0 | 0 | 0 | 0 |
D | 0 | 1 | 4 | 8 | 8 | 11 | 13 | 14 | 16 | 20 | 28 |
How would I alter the chain of tools to address this change?
Thanks!
-Luke
Thank you! I never would have thought excel would have been detrimental but I think some of the logic I've used in the past actually makes transitioning to this more effective solution harder than it needs to be! Looks like I have lots of practice in store...
-Luke