Calculate between two datasets with different attributes

Lindi94Lindi94 Member Posts: 2 Newbie
Hi Guys

I want to calculate fields from two datasets / .csv Files together.
The attributes from the two datasets are completely different.
In one dataset there are a few animals stored with the information of their weights (in gram) and the other dataset contains the price per gram.

I want to multiply every "weight" field from the first dataset with the "price" field from the second dataset.
As a result I want to get the price for the animal included in the first dataset.

See example for hopefully better understanding:

First dataset:
ID, Animal Name, Animal weight in gram
1, Dog, 1500
2, Cat, 800
3, Frog, 100

Second dataset:
ID, Price per gram
1, 0.015

RESULT included in the first dataset:
ID, Animal Name, Animal weight in gram, Price
1, Dog, 1500, 22.5
2, Cat, 800, 12
3, Frog, 100, 1.5

Thanks in advance for your help!



Sign In or Register to comment.