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 CodeCountryAgeQuantityProduct 1CanadaMale50Product 2IndiaMale50 CountryAgeSizeRatioCanadaMaleS.50CanadaMaleM.50IndiaMaleS.75IndiaMaleM.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 CodeCountryAgeSizeQuantityProduct 1CanadaMaleS25Product 1CanadaMaleM25Product 2IndiaMaleS37.5Product 2IndiaMaleM12.5 Can anyone point me in the right direction?

Multiplying Values by ratio from different Input

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?

Transformation

Accepted answers

EmanueleE

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

alteryx6.PNG

alteryx6.yxmd

All comments

EmanueleE

Hi @thelegazy;

here the solution;

Hope this help you.

EmanueleE

Thanks so much!

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703