Unique
What is the ‘Unique’ task?
The ‘Unique’ task can be used to identify all unique entries in a column in a data table. The ‘Unique’ task can create two tables as output. The first is a table of all first instances of unique entries. The second is table of all other entries. Thus, the ‘Unique’ task can be used a disassemble a data table into unique and duplicate records.
How to use the ‘Unique’ task?
The important fields in the ‘Unique’ task are
- Select Table
Use this dropdown menu to select the table from which you would like to identify unique entries.
- Select Columns to Find Unique Entries From
Use this dropdown menu to select the columns from which you would like to identify unique entries.
- Output Table Type(s)
Use this dropdown menu to select the output tables you would like to create. You can choose to have an output table of unique entries, or of duplicate entries, or both the tables.
- Standard Ending
Use this checkbox to indicate if you would like to have standard ending formats for the names of your output tables. The standard endings format for the table of unique entries is ‘Output Table Name_u’, and that for the table of duplicate entries is ‘Output Table Name_d’.
- Unique Output Ending
Use this field to type in and change the standard ending for the name of the table of unique entries.
This field becomes visible only if the ‘Standard Ending’ checkbox is unchecked.
- Duplicate Output Ending
Use this field to type in and change the standard ending for the name of the table of duplicate entries.
This field becomes visible only if the ‘Standard Ending’ checkbox is unchecked.
How to use the ‘Define Output Table’ and the ‘Output Options’ sections in the ‘Unique’ task?
The ‘Output Options’ section in the ‘Unique’ task can be used to modify features of the output table. The fields related to this section become visible on selecting the ‘Output Options’ checkbox.
More information about this section is available here.
