Compare Datatables

Custom Activity

Custom Activity
Community Support

Compare Datatables

Custom Activity

Summary: 

This activity compares two input DataTables and outputs three new DataTables

This activity provides a more user-friendly way to compare two DataTables based on the contents of the other. The input and output are as follows.
Use cases for this activity include:
  • Filtering an Excel sheet containing information about companies based on a table extracted from a website
  • Identifying records that are common to two tables of contacts that come from different sources
  • Eliminating duplicates that occur when aggregating CSV files corresponding to different periods of time
It compares two input DataTables and outputs three new DataTables with the following characteristics:
(1) Rows that belong only to the first input DataTable
(2) Rows that are common to both input DataTables
(3) Rows that belong only to the second input DataTable.
NOTE: Installation Guidelines for Custom Activities can be found here.

Details

Benefits

Convenient way to obtain the difference between DataTables as well as their intersection

Compatibility

UiPath Studio 2016.2
.NET Framework 4.5.2

Dependencies

No dependencies

Licensing

By clicking download you agree to the following license.