how to update value of repository file in process

sgnarkhede2016

Hello,

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

varunm1

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.

Test_Generate_Attributes.rmp