"How to generate attributes using attributes from two datasets (sources)"
Hello! I am new with rapidminer, and i am taking the first steps with ETL processes. Now, i have found a problem that i don't know how to solve it. In particular, I am looking for a way to generating new attributes applying function expressions where I need to use attributes from two database tables (dataset1, dataset2), where one of the tables (dataset2) has attributes that i need to use to calculate new attributes in the other table (dataset1).
Tables have different number of rows, and need to calculate a particular value of att1 in dataset1 to apply as a constant to calculate new attribute.
dataset1
att1 att2 att3
row1 1.1 1.2 2.3
row2 1 2.2 3.3
row3 1 2.4 5.3
dataset2
att1 att2 att3
row1 1.1 2 3
row2 1.2 2 3
row3 1.3 2 3
row4 1.4 2 3
row5 1.6 2 3
row6 1.7 2 3
Using Generate attributes
new attribute (dataset1)
dataset1.att4 = dataset1.att1 * dataset2.att1
Is it possible to use attributes from other datasets to calculate new attributes in other dataset?
Best regards,
alberto