Sign In
Create your first automation in just a few minutes.Try Studio Web →
Sopra Steria - Find Duplicates in Datatable
by Sopra Steria Ltd.
0
Snippet
132
Summary
Summary
Easily find duplicates in a Datatable based on a similar value of one or more columns
Overview
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)
Features
Features
Find duplicates in any Datatable. By default, the snippet is customized to check one column of each row. But, this can be modified to include more than one column.
Additional Information
Additional Information
Dependencies
UiPath.System.Activities : 20.4.0 UiPath.UIAutomation.Activities : 20.4.1
Code Language
Visual Basic
License & Privacy
Apache
Privacy Terms
Technical
Version
1.0.0Updated
June 12, 2020Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Support
UiPath Community Support
Similar Listings
