How to perform mutiplication/division of two data streams

[vx]

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!

[CharlieS · Accepted solution]

I've attached one option you could use. This transforms the table data to perform the operation, then transforms the resulting data back to the original structure.

[vx]

Hi Charlie,

That works great, thank you!

Best,

Vincent

[JakeHeisman]

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?

[nagakavyasri]

reuploading attached workflow