If you choose the Sort type in a transform process, one or more selected fields of data will be sorted. The result may vary according to the order of your selection. The upper field has a priority over the lower field in the Sort Transform.
The following table shows an example of the input:
| Field 1 | Field 2 |
|---|---|
| 4 | A |
| 2 | C |
| 1 | D |
| 3 | B |
Select Field 2, and select the Ascending order. Alternatively, you can select Field 1, and select the Descending order. The following table shows the output:
| Field 1 | Field 2 |
|---|---|
| 4 | A |
| 3 | B |
| 2 | C |
| 1 | D |