Database Reference
In-Depth Information
If you wish to sort the data in multiple columns, check the
Key
ports corresponding to the
required port.
Apart from ordering the data in ascending or descending order, you can also use the Sorter
transformation to remove duplicates from the data using the
Distinct
option in the proper-
ties. The sorter can remove duplicates only if the complete record is a duplicate and not
just a particular column. To remove a duplicate, check the
Distinct
option in the Sorter
transformation, as shown in the following screenshot: