• Reference Guide

Deduplication (Unicity)

Sometimes you may need to remove rows with duplicate values in a particular column. To do this, select the Disable duplicity of values option from the context menu of the column – the menu is invoked by right-clicking the header of the required column. If this option is selected (let’s say for column X), all rows are excluded from the view, that have a value in column X which has already occurred in the same column of any preceding row.
If you select multiple columns for deduplication, the values are combined so that only those rows are excluded, that have in these columns values which have occurred all together in the same combination on any preceding row.