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.