Columns to be checked

System.Object

-

Which columns should be checked for identical values? Enter the required column identifiers, e.g.: A,C-H,K

-

Case-sensitive?

System.Boolean

opt.

When checking for sameness, should upper and lower case letters be considered?

-

Action

System.String

• With identical rows, delete all but the last
• With identical rows, delete all but the first
• For identical lines - delete last line
• For identical lines - delete first line
• Only identical rows - delete all but the last
• Only identical rows - delete all but the first
• Keep all duplicate records

-

What should be deleted if rows in the selected columns have identical values?

-

Show number of records per identifier

System.Boolean

opt.

Should an additional column showing the number of duplicate data records be output?

-

Name of the result column

System.String

opt.

Input of the name of the result column.

-

Sort result according to the number of data records?

System.String

• No sorting
• Sort ascending
• Sort descending

opt.

Should the result be sorted by the number of identical data records?

-

Data already sorted?

System.Boolean

opt.

If "data already sorted" is not selected, then sorting takes place after the identification columns.

-

-

-