Chapter 7. Constant, Discard, Discard Duplicates, Reduce, Retain and Security Transforms

Table of Contents

Constant Transform
Discard Transform
Discard Duplicates Transform
Reduce Transform
Average
Comma Separated List
Comma Separated Set
Count
First
Last
Max
Median
Min
Product
Standard Deviation
Sum
Variance
Retain Transform
Security Transform
Column
Row
Row Credentials
Table

Constant Transform

If you choose the Constant type in a transform process, a new field of the specified constant value will be created.

The following table shows an example of the input:

ProductPrice before tax
A20.30
B15.99
C50.29

The following table shows an example of the output (Field: Tax, Data Type: String, Value: 7%):

ProductPrice before taxTax
A20.307%
B15.997%
C50.297%

Constant Transform can be used to mask fields. Use the name of an existing field as the name of the new field, and specify a constant value, for example, "Confidential". Values in that field will be reset to "Confidential".