Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
[SOLVED] join key
RapidEndUser
Member Posts: 10 Contributor II
Hi Rapid-I Support,
How can I join 2 tables using a key id?
I can see “join” operator but this shows just “inner”, “left”, ”right” and ”outer” joins but I don't see where can I join a field between two tables.
I am looking for an operator to join a field from table1 and a field from table2?
Thanks,
RapidEndUser.
How can I join 2 tables using a key id?
I can see “join” operator but this shows just “inner”, “left”, ”right” and ”outer” joins but I don't see where can I join a field between two tables.
I am looking for an operator to join a field from table1 and a field from table2?
Thanks,
RapidEndUser.
0
Answers
The JOIN operatior joins two tables using the IDs of both tables as key. If you want to use another field. You uncheck 'use id attribute as key' and you define the attributes to use pressing "Edit List".
I found it after experiment the operator.
-RapidEndUser.