Write Database Operator [Solved]
maccten
New Altair Community Member
Hi All,
I have a database in a postgreSQL database. The information in the tables within this database have missing values (2 columns, 2 fields)
I am using the Impute missing values using a decision tree to get the missing value which is very successful
I then wish to write this back to the postgresSQL database using the Write database Operator
The problem i have is when i set up the operator and specify the new table i wish to write to (oldTable_temp), I set the batch size but as soon as i move off the Operator to a different operator it resets itself to overwrite an existing table in the DB as opposed to the new table i have specified
Does anyone know why this may be happening? Am i attempting to do something not possible with the software
Thanks for your time
I have a database in a postgreSQL database. The information in the tables within this database have missing values (2 columns, 2 fields)
I am using the Impute missing values using a decision tree to get the missing value which is very successful
I then wish to write this back to the postgresSQL database using the Write database Operator
The problem i have is when i set up the operator and specify the new table i wish to write to (oldTable_temp), I set the batch size but as soon as i move off the Operator to a different operator it resets itself to overwrite an existing table in the DB as opposed to the new table i have specified
Does anyone know why this may be happening? Am i attempting to do something not possible with the software
Thanks for your time
0
Answers
-
It was related to the fact i had not updated rapid miner correctly
http://rapid-i.com/rapidforum/index.php/topic,6159.0.html
Thanks0