The RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent licensing related requests from Students/Faculty members, please use the Altair academic forum here.
Help with disappeared column
Good morning,
I am trying to use several join operators to be able to make 1 to n relationships from several tables created previously.
![Image: https://us.v-cdn.net/6030995/uploads/editor/45/kj2icq7jvy36.png](https://us.v-cdn.net/6030995/uploads/editor/45/kj2icq7jvy36.png)
That join seems to have only the new table Accessibility and the previously selected attributes.![Image: https://us.v-cdn.net/6030995/uploads/editor/m4/nlmtqrbnp3hv.png](https://us.v-cdn.net/6030995/uploads/editor/m4/nlmtqrbnp3hv.png)
The weird thing is that I have not selected Id_Marcas, anywhere and it appears alone.
![Image: https://us.v-cdn.net/6030995/uploads/editor/4l/rf2devkj63x2.png](https://us.v-cdn.net/6030995/uploads/editor/4l/rf2devkj63x2.png)
Where I have the box Rename, I have renamed id to id_marcas, as I am going to do many joins afterward. I don't get the point of reusing the column as there are different joins with different attributes and tables.
Thank you
![Image: https://us.v-cdn.net/6030995/uploads/editor/45/kj2icq7jvy36.png](https://us.v-cdn.net/6030995/uploads/editor/45/kj2icq7jvy36.png)
That join seems to have only the new table Accessibility and the previously selected attributes.
![Image: https://us.v-cdn.net/6030995/uploads/editor/m4/nlmtqrbnp3hv.png](https://us.v-cdn.net/6030995/uploads/editor/m4/nlmtqrbnp3hv.png)
The weird thing is that I have not selected Id_Marcas, anywhere and it appears alone.
![Image: https://us.v-cdn.net/6030995/uploads/editor/4l/rf2devkj63x2.png](https://us.v-cdn.net/6030995/uploads/editor/4l/rf2devkj63x2.png)
Where I have the box Rename, I have renamed id to id_marcas, as I am going to do many joins afterward. I don't get the point of reusing the column as there are different joins with different attributes and tables.
Thank you
Tagged:
0
Answers
these are the images of the process with the breakpoints.
Original process
After the replacing the null or inexistent values
The "marcas" table after "Id" column changes its name to "Id_Marcas"
The result of the first join
Result after selecting the valid attributes
The result after the 2nd join
Where has the id of accessibility gone?
Composition of the join
Thank you soo much
How to Post Questions on the RapidMiner User Community — RapidMiner Community
for the pictures I suppose that your Attributes are not the same type.
Best
I leave the code here
<?xml version="1.0" encoding="UTF-8"?>
Can you share a sample of your datasets?
Best
Please remove the "label" role to the id_Marcas Attribute. in some place you change the role of this attribute.
That's the why it appear, even if you don't select it.
Best
Now i'm confused. that is not the original question. If you want to preserve both attributes in in a join operator you need to check the option "keep the both join attributes" That's what you need?
Best
Did I make myself clearer?
Thank you for your time @ceaperez sorry for the misunderstanding.
Best
I know, i have an attribute called id. Even so, i change the name with a box called rename attribute to try that way not to overwrite the data i have. The point is that i don't know what is happening because the join doesn't give me the new id joined at the second join.
Something like this?