Defaults the values of the entire field if the field does not exist.
If the field exists, this function does nothing.
Helpful for populating a file with a minimum set of fields.
The first valid field will be used if a list of fields is provided.
default 'ORIGTERM' 360
default 'LTV' (100 times CURBAL eq APPVAL)
default 'RATETYPE' 'F'
default 'CURBAL,CBAL,CUR_BAL' 0
default 'FieldNames' Expression
Name | Data Type | Input Type | Description | Optional | Default |
---|---|---|---|---|---|
FieldNames | Text | Constant | comma separated list of fields to check if exist. | No | |
Expression | Text, Boolean, Numeric, Date | Constant | Expression result value if no default field exists. | No |
Type: Text, Numeric, Date, Boolean
Value type same as result.