If you choose the Retain type in a transform process, only the selected columns will be present in the result. This is important for Reduce Transform, which requires corresponding rows to have the same values in order to be grouped together. Use Retain Transform in conjunction with Reduce Transform to keep only the relevant columns and make sure the grouping can function.
The following table shows an example of the input:
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | 10 | 5.1 |
| A | B | C | 10 | 7.1 |
| A | B | C | 10 | 9.1 |
| D | E | F | 0 | 1.2 |
| D | E | F | 0 | 3.2 |
The following table shows an example of the output (Selected columns: Field 1 and Field 5):
| Field 1 | Field 5 |
|---|---|
| A | 5.1 |
| A | 7.1 |
| A | 9.1 |
| D | 1.2 |
| D | 3.2 |