Uipath Marketplace
MarketplaceListingsSnippetSopra Steria - Find Duplicates in Datatable

Create your first automation in just a few minutes.Try Studio Web

Sopra Steria - Find Duplicates in Datatable

Sopra Steria - Find Duplicates in Datatable

by Sopra Steria Ltd.

StarStarStarStarStarStarStarStarStarStar

0

Snippet

Downloads

128

back button
back button
carouselImage0
next button
next button

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

Publisher

Sopra Steria Ltd.

Visit publisher's page

Trusted Source

License & Privacy

Apache

Privacy Terms

Technical

Version

1.0.0

Updated

Jun 12, 2020

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Support

UiPath Community Support

Similar Listings