"How to update rows in database table?"
Hi everybody,
I am newbie to RapidMiner and I would greatly appreciate if anybody can help me with following problem
After I run classification model I get example set as output with classification label, now I need to go back and update label column in sql server database for each row in exampleset, I tried to use 'Execute SQL' operator, but I don't know how to iterate thru exampleset inside this operator, is that the right operator to use or is there built-in operator that can update row in sql table?
I am newbie to RapidMiner and I would greatly appreciate if anybody can help me with following problem
After I run classification model I get example set as output with classification label, now I need to go back and update label column in sql server database for each row in exampleset, I tried to use 'Execute SQL' operator, but I don't know how to iterate thru exampleset inside this operator, is that the right operator to use or is there built-in operator that can update row in sql table?