Edit SQL query

tabdelmonem
tabdelmonem New Altair Community Member
edited November 5 in Community Q&A

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

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    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

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    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
    tabdelmonem New Altair Community Member

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

Categories