Transformation usage:
Note :I am using flat file as a source
Filter Transformation to filter NULL values in the ID column.
Sorter Transformation to avoid duplicates.
Expression Transformation to trim the blank spaces at the left and right sides.