🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

how to pass one attribute values from one process to other process

sgnarkhede2016User: "sgnarkhede2016"
New Altair Community Member
Updated by Jocelyn
Hello,
I have one process that cotains atttribute  "Name" with value "Sachin"

In my other process i want to retrieve records of only "Sachin" that mentioned above 

Thanks In Advance

Find more posts tagged with

Sort by:
1 - 2 of 21
    BalazsBaranyRMUser: "BalazsBaranyRM"
    New Altair Community Member
    Accepted Answer
    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
    BalazsBaranyRMUser: "BalazsBaranyRM"
    New Altair Community Member
    Accepted Answer
    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