Identify duplicates

Thu, 08/18/2011 - 10:51 dmt

How many times have you created a unique key that turned out not to be unique at all? It happens quite often. The problem is: how do we verify that a unique key is actually unique? I use the "RowID" node. The "RowID" node replaces the RowIDs of the input data with the values of another column, assuming that such values are unique. Indeed, if the checkbox "Ensure uniqueness" is NOT enabled, the "RowID" node will fail on non-unique values and the error message describes the first non-unique encounter as: "ERROR RowID Execute failed: Encountered duplicate row ID "" at row number "