Edit SQL query

tabdelmonem

Hey everyone, 

 

I am new to Rapidminer (started today) and I was able to create a connection to the db, ran a query and created a process to export to csv - excellent.

 

However, I want to change the date range in the where clause, but I cannot figure out how to do that. I am using the latest Mac desktop version

 

The closest thing that I have found was to click on "Add Data," create and overwrite the same data storage with the same name, but I will not always have the SQL query in the clipboard for future references. How can I modify/edit the original SQL query used to create the result set

 

Thanks in advance

MartinLiebig

Hello!

 

If you use a Read Database operator you can provide a SQL statement with your WHERE statement included. That should solve the problem.

 

Best,

Martin

tabdelmonem

Thank you @mschmitz, that worked. Now how do I mark a question as solved?