The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"Join by ID"

kavuchkavuch Member Posts: 6 Learner III
edited June 2019 in Help
I have 2 CSV-files.

Events: 
id,event,day
1,work,1
2,work,2
3,theatre,2
4,work,3
5,work,4
6,work,5
7,trip,6
8,sport,7
9,relax,7
Days of week: 
id,day
1,monday
2,tuesday
3,wednesday
4,thursday
5,friday
6,saturday,
7,sunday
I want to join both files, so that I have the real days of weeks instead of their ids.

I imported both files and used the Join-operator. There I specified as left key attribute "day" and as right key attribute "id":

image

When I run the process, I only see the ids instead of the days of the week:

image
Tagged:

Answers

  • sgenzersgenzer Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    hi...that's because you have the attribute "day" in both datasets.  Check the optional box "keep both join attributes" or rename one of your "day" attributes.  :)

    By the way, if you assign the ID role to "id" in both sets and check the box "use id attribute as key", you don't have to manually select the ID attributes in the join options.

    Enjoy!

    Scott
Sign In or Register to comment.