Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Expression macro configuration

Expression macro configuration

Configure an expression macro on the Configuration tab of the Expression or Aggregator object properties dialog box.
When you configure an expression macro, use one row for the macro variable declaration and another for the macro statement. Enter expression macro elements in the Port Name and Expression columns as follows. Data type and port type information is not relevant:
Expression macro part
Port name
Expression
Macro variable declaration
Macro variable name.
For example:
Declare_%addressports%
Macro variable fields.
For example:
{"addrport":"Pattern:^addr"}
Macro statement
Output field names.
For example:
ISNULL
Macro expression.
%OPR_SUM[IIF(ISNULL(%addrport%),1,0)]%