Edit SQL query

tabdelmonemtabdelmonem Member Posts: 2 Contributor I
edited November 2018 in Help

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

Best Answer

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    Solution Accepted



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




    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany


Sign In or Register to comment.