how to update value of repository file in process

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II

e.g I have one uploded excel in repository that contains column "Name"   "Marks"  "Grade"

I want update grade attribute through the process like if marks>70 Distinction >60 first


  • Options
    varunm1varunm1 Moderator, Member Posts: 1,207 Unicorn
    Hello @sgnarkhede2016

    If you want to update a column based on an existing column, you can use generate attributes to do that. You need to use same column name as Grade and write the condition in generate attribute, it will replace existing attribute, Once this is done you need to use "store" operator to store the new data with the same name as your original repository file in the same place, it will modify the existing file.

    I attached a process for your reference. Download this .rmp file and upload in your Rapidminer using File --> Import process to check the flow. You can also check the conditions I wrote in generate attributes.

    Do let us know if this helps. If not, please provide detailed information about your request.

    Be Safe. Follow precautions and Maintain Social Distancing

Sign In or Register to comment.