"How to pass calculated parameters to Execute SQL operator?"

MacPhotoBikerMacPhotoBiker Member Posts: 60 Contributor II
edited June 2019 in Help
Hi,

I'm trying to run an SQL statement with with parameters I calculated in previous statements.

For example, the statement "DELETE FROM `Table` WHERE `Year` = 2015" works just fine.

However, I'd like pass the year (2015) as a parameter value because the value is being calculated dynamically.

The statement I'm trying to execute is

"DELETE FROM `Table` WHERE `Year` = CalculatedYear"

How could I achieve this?
Tagged:

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,453 RM Data Scientist
    You can use it as a macro and use %{calculatedYear}.

    you can either look at the context menu or use the operators, e.g. extract macro.


    Cheers,

    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • KintaroKintaro Member Posts: 7 Contributor I
    this method can be used to pass an extracted text from GetPage to another GetPage, too?
  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,453 RM Data Scientist
    Of course.

    The method of Macros (better name: Process variables) enables you to get information from one point to the other or control several operators at a time.

    If you need further help just post here


    Cheers,

    martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.