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

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

    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

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

Answers

Sign In or Register to comment.