Transformations

Back Next

Output macro field

Create an output macro field to define the calculations that you want to perform on all incoming fields or constants. The macro input field represents the incoming fields or constants.

The following table describes the properties you can define when you create an output macro field.

Property	Description
Input Macro Field	Name of the input macro field that represents the input of the expression macro.
Output Macro Field	Name of the output macro field in the following format: <prefix>%<input mactiro field name>%<suffix> The output macro field name must contain either a prefix, suffix, or both.
Suffix	Suffix of the output macro field name. Default is _out.
Prefix	Prefix of the output macro field name. Default is none.
Type	The data type of the field.
Precision	Total number of digits in a number. For example, the number 123.45 has a precision of 5. The precision must be greater than or equal to 1. You cannot specify a decimal field precision greater than 38.
Scale	Number of digits to the right of the decimal point of a number. For example, the number 123.45 has a scale of 2. Scale must be greater than or equal to 0. The scale of a number must be less than its precision. The scale may cause zero-filling or truncation with rounding. For example, a scale of 5 causes 123.45 to be expressed as "123.45000" while 123.456789 becomes "123.45679".
Description	Optional. Description of the field. The description can contain up to 4000 characters.

Rename Saved Search

Table of Contents

Transformations

Transformations

Output macro field

Output macro field