Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r093


  1. For the recipe on which you are working, create a new recipe. 
  2. In this new empty recipe, add the following steps.
    1. Redact social security numbers:
      D trans
      SearchTermEdit formula
    2. Redact credit card numbers: For this one, you can use the following transformation to mask the numbers except for the last four digits using

      D s lang
      D trans
      p03NameReplace with
      SearchTermReplace text or patterns


      NOTE: The above transformation matches values based on the structure of the data, instead of the data type. If for some reason, you have values that are not credit card numbers yet follow the credit card pattern, those values will be masked as well by this transformation.

  3. Select the above steps. In the context menu, select  Create or replace macro. For more information, see Create or Replace Macro. 
    1. Enter a Name and optional Description value. Click Next.
    2. In the Create Macro dialog, you can review the step and its specified field values. 
      1. You may wish to parameterize the Find and Replace with values. For example, for some uses of the macro, you may wish to replace with an empty string or a value like ##REDACTED## like the previous macro. 
    3. To save the macro, click Save.
  4. For any recipe that must generate results for this downstream system, you can insert this macro as the last step before publication. For example, you can delete the recipe where you made the macro and insert the macro reference in the preceding recipe.


  • Create macro inputs: Macro inputs can be defined when you create a new macro. 
  • Reuse or replace macro inputs: When you replace a macro, you can reuse or replace the existing macro inputs in the new version of a macro. 
    • If you are reusing the existing macro inputs, you must map them to the new steps in the new version of the macro
    • If you are replacing macro inputs, instances of the macro that were added to your recipes under the old definition must be updated.
    For more information, see Create or Replace Macro
    • .


After a macro is created, you can apply an instance of it anywhere in your recipes. See Apply a Macro.


All macros are included. Steps are not expanded.

Share a flow:

When a flow is shared, the flow owner's macros are available for use by any collaborator in the recipes of the shared flow.



NOTE: Exported macros can be imported into a release that is later than the source release of the product. Exported macros cannot be imported into earlier releases.


After macros have been created, you can manage them through the Library. For more information, see Macros Page.

D s also