DB_Table.duplicates

duplicatescolumnscase_sensitivityon_problems

Group: Selections

Documentation

Returns the set of rows which are duplicated within the specified columns from the input table. When multiple rows have the same values within the specified columns all of those rows are returned. Rows which are unique within the specified columns are removed.

Arguments

• columns: The columns of the table to use for distinguishing the rows.
• case_sensitivity: Specifies if the text values should be compared case sensitively.
• on_problems: Specifies how to handle if a problem occurs, raising as a warning by default.

Errors

• If there are no columns in the output table, a No_Output_Columns is raised as an error regardless of the problem behavior, because it is not possible to create a table without any columns.
• If a column in columns is not in the input table, a Missing_Input_Columns is raised as an error.
• If no valid columns are selected, a No_Input_Columns_Selected, is reported as a dataflow error regardless of setting.
• If floating points values are present in the distinct columns, a Floating_Point_Equality is reported according to the on_problems setting.