MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Conditional replace | Parameters
 
Parameters
The following parameters are available.
Action
Result
Column
Name of the column whose values are replaced.
Source: Source table
Data type: Number, Text, Date;
Specification: Mandatory
New value
Value that replaces the value in the source column.
Source: Column with values, single value from a feed (single-value operator), user input, or a constant.
Default value: is equal to
Specification: Mandatory
Replace
Values are replaced if one or all conditions is/are met.
Source column
Name of the column whose values are compared.
Source: Source table
Data type: Number, Text, Date;
Specification: Mandatory
Comparison operator
Operator that compares the values from the source column with the comparison values.
Available comparison operators depend on the data type of the source column.
Default value: is equal to
Specification: Mandatory
Comparison values
Values that are compared with the values from the source column.
Source: Column with values, single value from a feed (single-value operator), user input, or a constant.
Data type: Must be identical to that of the source column.
Comparison value missing
*Condition met: If a comparison value is missing, the condition is assumed to be met.
*Condition not met: If a comparison value is missing, the condition is assumed to not be met.
Specification: Mandatory

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release