Data Integration
- Data Integration
- All Products
Macro variable declaration element
| Description
| Syntax
|
---|---|---|
Macro variable name
| Macro variable name. Use a logical name.
|
|
Macro variable fields
| Fields to be used in the macro expression.
You can list field names, create an expression to define the field names, or use a link rule.
For example, you can use the following syntax to apply a macro across all fields in the object:
When listing field names, use a comma delimited list.
You can create more than one set of variable fields as follows:
When you use a variable in an expression, enclose the variable name in percent signs, as follows:
|
|
Macro statement element
| Description
|
---|---|
Output field names
| Expression that defines the field names for the output fields generated by the expression macro.
You can use variables and rules to help define output field names, such as <%field%>_out.
|
Macro expression
| Expression to be used.
|
Macro variable name: Declare_%addressports% Macro variable fields: {"addrport":"Pattern:^addr"} Output field names: ISNULL Macro expression: %OPR_SUM[IIF(ISNULL(%addrport%),1,0)]%