Compare Datatables

Bronze Certified

Custom Activity

11 reviews

6.9k

Compare Datatables

Bronze Certified

Custom Activity

11 reviews

6.9k


Summary

This activity compares two input DataTables and outputs three new DataTables

Overview

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.

Benefits


Published: 21 Sep 2018 | Updated: 18 Dec 2020


License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

.NET Core


Tags

compare
datatable

Compatibility

Studio: 2018.4+


Dependencies

No dependencies


Similar Listings