If you choose the Security type in a transform process, you can specify which users and groups will be able to access data from the selected columns, the selected rows where the column value is true (Boolean type), or the entire table.
The following table shows an example of the input (Field 4 is in Boolean type):
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| A | B | C | true | 5.1 |
| A | B | C | true | 7.1 |
| A | B | C | true | 9.1 |
| D | E | F | false | 1.2 |
| D | E | F | false | 3.2 |
The specified users and groups receive an output exactly the same with the input. On the contrary, the following table shows the output for unspecified users and groups (Selected column: Field 2; selected rows: those including true column value in Field 4):
| Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
|---|---|---|---|---|
| D | F | false | 1.2 | |
| D | F | false | 3.2 |