Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"How to pass calculated parameters to Execute SQL operator?"
MacPhotoBiker
Member Posts: 60 Contributor II
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?
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:
0
Answers
you can either look at the context menu or use the operators, e.g. extract macro.
Cheers,
Martin
Dortmund, Germany
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
Dortmund, Germany