The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"Formatting several Read Database queries at once"

jaakko1jaakko1 Member Posts: 8 Contributor II
edited June 2019 in Help
Hello all,

I have a process with ten different "Read Database" operators that all include an SQL script with a date in them. I would like to be able to change this date on all the operators at once without having to click through all the operators and change the date individually. Is there a way to do this? Many thanks again in advance for your help.
Tagged:

Answers

  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee-RapidMiner, Member, University Professor Posts: 1,996 RM Engineering
    Hi,

    you can use macros for that. For example, using the following query in a Read Database operator replaces the FROM clause with the macro value specified: 

    SELECT %{name} FROM test;
    To set a macro you can either define it in the process context (View -> Show View -> Context) or use one of the macro operators.

    Regards,
    Marco
Sign In or Register to comment.