Hi guys,
I think this is a very basic question, but I'm new to Alteryx and somehow I can't figure it out.
I want to do the following; take data stream A which has the form (it's coming from a summarize)
Table A
Team | q1 | q2 | (...) | qN |
Team1 | 1 | 2 | ... | 3 |
(...) | .. | ... | ... | ... |
Team N | 5 | 8 | ... | 10 |
then take data stream B, which has exactly the same form, but with different numbers
Team B
Team | q1 | q2 | (...) | qN |
Team1 | 5 | 6 | ... | 7 |
(...) | .. | ... | ... | ... |
Team N | 10 | 3 | ... | 4 |
I want to create an output (Table C), which will have the same shape, but where the values are the RATIO of the two tables
Table C
Team | q1 | q2 | (...) | qN |
Team1 | 1/5 | 2/6 | ... | 3/7 |
(...) | .. | ... | ... | 3 |
Team N | 5/10 | 8/3 | ... | 10/4 |
This seems like something that would be easy to do in Excel, but this will be part of a larger workflow in Alteryx...
Note1: I know I could use Summarize if I wanted to take the sum, but I'm interested in the ratio of the two, and also eventually the difference.
Thanks!
Solved! Go to Solution.
Hi Charlie,
That works great, thank you!
Best,
Vincent
Hi Charlie,
I am trying to find a similar solution, but Alteryx cannot open the file attached anymore. Would you be able to reupload it?