Apply DataTable Operations

Compare two DataTable inputs to perform required operations.

This activity is used to compare DataTables to get matched, unmatched, or combine the list of all rows in the DataTable inputs.

Input

• DataTable 1 : DataTable Variable Specifies the first DataTable to compare values.

• DataTable 2 : DataTable Variable Specifies the second DataTable to compare values.

• DataTable Operations : Specifies the type of data table operations to be used on the DataTable inputs. The data table operations available are:-

  • Except - To retrieve unmatched records from the first table.

  • Intersect - To retrieve all the rows which are in both tables.

  • Union - To retrieve the combined data from both the DataTable inputs. It does not repeat the DataRow even if it exists in multiple DataTables.

Output

• Output: DataTable Variable Specifies the variable that stores the resulting data table of the DataTable operation.