The Unique rows step removes duplicate rows from the input stream(s).
Important: Make sure that the input stream is sorted; otherwise, only consecutive double rows are evaluated correctly.
Options
The table below contains descriptions of all options for the Unique rows step:
| Option | Description |
|---|
| Step name | Name of the step; this name has to be unique in a single transformation |
| Add counter to output? | |
| Fields to compare table | Specify the field names on which you want to force uniqueness or click Get to insert all fields from the input stream(s) You can choose to ignore case by setting the Ignore case flag to Y. For example: Kettle, KETTLE, kettle are the same if the compare is performed as case-insensitive. In this instance, the first occurrence (Kettle) is passed to the next step(s). |
No comments:
Post a Comment