Sopra Steria - Find Duplicates in Datatable

Bronze Certified

Snippet

0 reviews

Version:1.0.0

Overview Reviews Questions

Versions

Summary

Easily find duplicates in a Datatable based on a similar value of one or more columns

Overview

Functionality:

The sequence iterates through every row of the Datatable and checks if the value of the specified column has been repeated.

A column "Duplicate Status" is added in the Datatable in which the status "Duplicate" is updated for the rows having repeated value. No status is updated for the first row as it would be the original (unique) row.

For example: 

Order No.    Supplier    Quantity
123A             X Corp       10
456B             Y Corp        20
789C             Z Corp        30
456B             W Corp       25

If the above Datatable is passed in the snippet and column name is updated as "Order No.". then, the below Datatable will be the output:

Order No.    Supplier    Quantity    Duplicate Status
123A             X Corp       10               
456B             Y Corp        20
789C             Z Corp        30
456B             W Corp       25              Duplicate


Input: 

1. Datatable in which duplicates are to categorized (in_Datatable)
2. Column name which has to be validated (in_MatchColumnName)

Output:

Datatable with additional column "Duplicate Status" (out_Datatable)

Benefits

Published: 12 Jun 2020 | Updated: 21 Oct 2020

Sopra Steria Ltd.

Trusted Source

License

Apache 2.0

Code Language

Visual Basic

Runtime

.NET Framework

Rename Multiple Columns in DataTable…

Custom Activity

Rename Multiple Columns in DataTable…

498

Bronze Certified

Supported by Publisher

DataTable Manipulation…

Custom Activity

The Package contains multiple activities which are used to manipulate DataTable in a more advanced way like selecting and removing particular columns and row etc..…

2 reviews

950

Bronze Certified

Supported by Publisher

DataTable Utility Activity…

Custom Activity

This Custom Activity provides the ability to convert DataTable to HTML table, convert to JSON, find Min,Max and Average of a column, find column names and rename column in a DataTable…