🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Divide a column values with a column in another table.

User: "Teja_Varanasi"
Teja_Varanasi
New Altair Community Member
Updated by Jocelyn
I have a Table with these columns

A  B  C  D
2  3   4  3
4  6   8  6
6  9   2  3
8  3   6  9

I have another table with same column names

A  B  C  D
2  3   2   3

I want to get the result 
A  B  C  D
1  1   2  1
2  2   4  2
3  3   1  1
4  1   3  3

can anyone suggest what should i do here

Find more posts tagged with

AI Studio
Generate Attributes
Sort by:
1 - 1 of 11
    User: "Mo Abdolrahim"
    Mo Abdolrahim
    Altair Employee
    Accepted Answer
    Hi Teja,  I was able to do this in Rapidminer Studio v10.  I used two Read CSV Operators for reading data.  Then I used two Generate Attribute Operators and added an id field wit value of one (1).  Then I added an Inner Join Operator and joined Id from both tables.  Finally I added a Generate Attribute Operator and divide data in one column with another column.  Please see screenshots below:
    Regards
    Mo









    View in context
Quick Links