Home
Discussions
Community Q&A
Export the result of process with write database
ABIM
Hello
I try to install AI hub but unfortunately it has 404 error and I can not run the server and service. Now the question is this:
How can I export
the result of process
with out server(AI hub)? Can I use write database to export the result of my process? ( please explain your answer)
Thank you very much
A
Find more posts tagged with
AI Studio
Accepted answers
BalazsBaranyRM
Hi
@ABIM
,
there is no "best" option here. It depends on your needs - if you are in a company and want to integrate the results, a database might be the best option (the one the company already uses, or a Free one like PostgreSQL if you don't use one yet).
If you want to communicate your results to other people, the Excel export might be the right one.
In your example screenshot you're inside the cross validation. It can make sense to log the intermediate results of the validation e. g. into a database, but that's not a frequent use case. I guess you would rather go to the main process and insert your Write operator after the cross validation, connected to the output you're interested in.
Regards,
Balázs
All comments
BalazsBaranyRM
Hi
@ABIM
,
Read Database is for reading data from a database. But there are many operators for exporting the result of your process:
Write Database (append data to a database table), Update Database (insert or update based on a key), Write Excel (for exporting spreadsheet files), Write CSV etc.
Regards,
Balázs
ABIM
@BalazsBarany
Thank you very much for your reply. Which one is the best for the result of oracle?
How should I add it to my process?( at the end of my process?)
Regards
A
BalazsBaranyRM
Hi
@ABIM
,
there is no "best" option here. It depends on your needs - if you are in a company and want to integrate the results, a database might be the best option (the one the company already uses, or a Free one like PostgreSQL if you don't use one yet).
If you want to communicate your results to other people, the Excel export might be the right one.
In your example screenshot you're inside the cross validation. It can make sense to log the intermediate results of the validation e. g. into a database, but that's not a frequent use case. I guess you would rather go to the main process and insert your Write operator after the cross validation, connected to the output you're interested in.
Regards,
Balázs
ABIM
Thank you very much! Your answer is very useful
I will try it.
Regards
A
ABIM
@BalazsBarany
Hello
Sorry I am a bit new for some part of rapidminer.
I did a simple example with a simple data in my pc and connect the cross validation with write excel, but the result was:"
file memory buffered file"
why?
Please tell me if I save the result like this in an excel file or in a read data base, what will save there?( my data which classify there?) Where can I find that excel?( in repository? or in my data base?)( because I want my friends use the result of process in a program) Can you please show me an example?
Best Regards
A
lionelderkrikor
Hi
@ABIM
I think you have connected the
fil
(file) output port of the
Write Excel
operator to the
res
port.
You have to connect the
thr
(through) output port of the
Write Excel
operator (instead the
fil
output port).
EDIT :
After doing this new connection , you can set the folder and the name of the generated Excel file (xls/xlsx file)
in the parameters of the
Write Excel
operator.
Regards,
Lionel
ABIM
@lionelderkrikor
Hello
Thank you for reply. Unfortunately I don't know how to create a folder also there is no result to save.
Best regards
A
lionelderkrikor
@ABIM
,
Deconnect the connexion between the
inp
port and the
fil
input port of the
Read Excel
operator (the first connexion of your process)
Then set the path/excel file you want to read in the parameters of the
Read Excel
operator.
Regards,
Lionel
ABIM
@lionelderkrikor
Sorry, it is not clear for me also there is some error so please send me screen to see the connections.( please show me one for write excel and one for read database)
Best Regards
A
BalazsBaranyRM
Hi
@ABIM
,
right click on an operator (e. g. Cross Validation) and select "Breakpoint after". This will pause the execution after the operator and show you the result of it. If you get results, these will also show up in the Excel file.
The connections are right, you just need to select a correct file name with the file selector for Write Excel and a correct database connection with either permissions for creating a table, or an existing table with the necessary attributes/columns.
Please familiarize yourself with the basic working of RapidMiner before asking questions here. There are plenty of tutorials and videos in the Academy.
If you get an error message, the most basic reasonable action is to post it. Nobody will be able to help you with "some error message".
Regards,
Balázs
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)