The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

Tagged:

Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 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.