Find more posts tagged with
Sort by:
1 - 6 of
61
Hi,
likely you want to use Extract Macro and hand it over as a macro.
Best,
Martin
Hi,
you can define macros in the process context. (Activate the Process Context panel in the View menu if you didn't yet.) These macros (text variables) are available as the process parameter interface. In Execute Process you can specify the macros and their values to pass into the subprocess.
Regards,
Balázs
you can define macros in the process context. (Activate the Process Context panel in the View menu if you didn't yet.) These macros (text variables) are available as the process parameter interface. In Execute Process you can specify the macros and their values to pass into the subprocess.
Regards,
Balázs
Hi,
there's a detailed video on the Academy about the the different ways to define macros, including the process context.
https://academy.rapidminer.com/learn/video/macros-demo
Regards,
Balázs
there's a detailed video on the Academy about the the different ways to define macros, including the process context.
https://academy.rapidminer.com/learn/video/macros-demo
Regards,
Balázs
Hi!
In xyz.rmp you define the macro "name" with an initial value for testing your process.
Whenever you start the process, the macro will be already defined.
For accessing the parameter in Read Database use "prepare statement" and enter the macro value in the Edit Enumeration window. To refer to the macro value, use this syntax: %{macroName}
Inside the SQL query in Read Database you have to write a question mark to refer to the current value. E. g.:
select *
from mytable
where name = ?
It is also possible to write the macro directly into the SQL statement (where name = '%{macroName}'). However, this can lead to SQL injection or syntax errors, so the prepared statement way is much better.
In abc.rmp you use Execute Process and enter the macro name and value to pass to xyz.rmp.
Regards,
Balázs
In xyz.rmp you define the macro "name" with an initial value for testing your process.
Whenever you start the process, the macro will be already defined.
For accessing the parameter in Read Database use "prepare statement" and enter the macro value in the Edit Enumeration window. To refer to the macro value, use this syntax: %{macroName}
Inside the SQL query in Read Database you have to write a question mark to refer to the current value. E. g.:
select *
from mytable
where name = ?
It is also possible to write the macro directly into the SQL statement (where name = '%{macroName}'). However, this can lead to SQL injection or syntax errors, so the prepared statement way is much better.
In abc.rmp you use Execute Process and enter the macro name and value to pass to xyz.rmp.
Regards,
Balázs
Sort by:
1 - 2 of
21
Hi,
there's a detailed video on the Academy about the the different ways to define macros, including the process context.
https://academy.rapidminer.com/learn/video/macros-demo
Regards,
Balázs
there's a detailed video on the Academy about the the different ways to define macros, including the process context.
https://academy.rapidminer.com/learn/video/macros-demo
Regards,
Balázs
Hi!
In xyz.rmp you define the macro "name" with an initial value for testing your process.
Whenever you start the process, the macro will be already defined.
For accessing the parameter in Read Database use "prepare statement" and enter the macro value in the Edit Enumeration window. To refer to the macro value, use this syntax: %{macroName}
Inside the SQL query in Read Database you have to write a question mark to refer to the current value. E. g.:
select *
from mytable
where name = ?
It is also possible to write the macro directly into the SQL statement (where name = '%{macroName}'). However, this can lead to SQL injection or syntax errors, so the prepared statement way is much better.
In abc.rmp you use Execute Process and enter the macro name and value to pass to xyz.rmp.
Regards,
Balázs
In xyz.rmp you define the macro "name" with an initial value for testing your process.
Whenever you start the process, the macro will be already defined.
For accessing the parameter in Read Database use "prepare statement" and enter the macro value in the Edit Enumeration window. To refer to the macro value, use this syntax: %{macroName}
Inside the SQL query in Read Database you have to write a question mark to refer to the current value. E. g.:
select *
from mytable
where name = ?
It is also possible to write the macro directly into the SQL statement (where name = '%{macroName}'). However, this can lead to SQL injection or syntax errors, so the prepared statement way is much better.
In abc.rmp you use Execute Process and enter the macro name and value to pass to xyz.rmp.
Regards,
Balázs