Chapter 6. Discard, Discard Duplicates, Reduce and Security Transforms

Table of Contents

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
Security Transform
Column
Row
Row Credentials
Table

Discard Transform

If you choose the Discard type in a transform process, selected columns will not display in the result.

The following table shows an example of the input:

Field 1Field 2Field 3Field 4Field 5
ABC105.1
ABC107.1
ABC109.1
DEF01.2
DEF03.2

The following table shows an example of the output (Selected columns: Field 2 and Field 3):

Field 1Field 4Field 5
A105.1
A107.1
A109.1
D01.2
D03.2