How to perform mutiplication/division of two data streams

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!

Common Use Cases

Accepted answers

CharlieS

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.

Table Transform.yxmd

All comments

CharlieS

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.

Table Transform.yxmd

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

Table Transform.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703