Multiplying Values by ratio from different Input
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :)
