MarketplaceListingsSnippetSopra Steria - Find Duplicates in Datatable

Sopra Steria - Find Duplicates in Datatable

by Sopra Steria Ltd.

0

103

Sopra Steria - Find Duplicates in Datatable

by Sopra Steria Ltd.

0

Snippet

103

carouselImage0

Summary

Summary


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


Additional Information

Additional Information

Dependencies


Code Language

Visual Basic

Publisher

Sopra Steria Ltd.

Visit Publisher's Page

Trusted Source

License

Apache

Technical

Version

1.0.0

Updated

12 Jun 2020

Works with

UiPath 2020.4 +

Certification

Silver Certified

Tags

datatable
duplicates in datatable
Find duplicates
find duplicates in datatable

Support

UiPath Community Support

Similar Listings