Multiplying Values by ratio from different Input

[thelegazy]

Hi All, 

Need some newbie help. I tried researching as much as I could, but couldn't really find anything. 

I have the following two data sets being brought in from two different inputs: 

Product Code	Country	Age	Quantity
Product 1	Canada	Male	50
Product 2	India	Male	50

Country	Age	Size	Ratio
Canada	Male	S	.50
Canada	Male	M	.50
India	Male	S	.75
India	Male	M	.25

Desired Result:

I want to multiply the Ratio in the second table against the Quantity in the first table using the Country and Age as the look up criteria. 

Product Code	Country	Age	Size	Quantity
Product 1	Canada	Male	S	25
Product 1	Canada	Male	M	25
Product 2	India	Male	S	37.5
Product 2	India	Male	M	12.5

Can anyone point me in the right direction? 

[EmanueleE · Accepted solution]

Hi @thelegazy;

here the solution;

Join 2 dataset with country (remember to change the type field from byte to double for the "left quantity"); do a multiplication with the formula tool (left quantity * right quantity) and at the last use the select tool "to clean" the output. In the attachment an example file.

Hope this help you.

EmanueleE

[thelegazy]

Thanks so much!

[DiyaR]

Hi,

I have similar situation but unable to find solution. I have USD conversion rate in different input and want to multiply data in other input. I don't have any common field which I can join. Is there any way to multiply without joining the fields.

Thank you :)