Difference between revisions of "Drop Duplicate Rows"

From PresenceWiki
Jump to: navigation, search
 
Line 4: Line 4:
  
 
http://www.international-presence.com/wikidocs/images/remove_duplicates_illustration.png
 
http://www.international-presence.com/wikidocs/images/remove_duplicates_illustration.png
 +
 +
{{DataTableNodes}}

Revision as of 10:35, 23 June 2010

The Drop Duplicate Rows Node performs the equivalent to a "Select DISTINCT" operation on the current Data Table. Rows that are considered to be duplicates of other rows are removed. A duplicate row is one that contains identical values as another row.

Please see the example below, of a Data Table before and after executing a Drop Duplicate Rows Node (rows which will be deleted are marked with a red cross).

http://www.international-presence.com/wikidocs/images/remove_duplicates_illustration.png


Data Filter | Require Columns | Append Data Column | Multiple Column Appender

Drop Column | Drop Row(s) | Calculate Column Aggregate | Dataset Splitter | Merge Data

Create Data Table | Clear Data Table | Sort Data Table | Drop Duplicate Rows | Store Data Table | Retrieve Data Table


Task Elements > Data Table Nodes > Drop Duplicate Rows