Compare Datatable

This activity helps the user to compare between two datatables and provides the updated, modified or findings as result.

Properties

Input

Compare Type: Specifies how the rows in the DataTable are compared during matching or lookup operations.

Full: Compares all columns in the DataTable. A row is considered a match only when every column value is identical between the compared rows.
Primary Key: Compares rows using only the primary key column(s). If the primary key matches, the row is considered a match, even if other column values are different.

Ignore Case: When enabled, it ignores letter casing while searching. Uppercase and lowercase letters are treated the same when matching values.

Ignore Order: Compares rows without considering their position in the DataTable. Even if the rows appear in a different order, they are still treated as matching based on the comparison type.

Key Columns: Specifies the columns used to identify and match values and accepts the list of column names in List of String format.

Source Datatable*: Specifies the source DataTable that contains the values to be matched.

Target Datatable*: Specifies the target DataTable where the matching values will be searched.

MISC

Display Name: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

Output

Added Rows: Returns the rows that exist in the target table but not in the source table in a structured DataTable format.

Modified Rows: Returns the rows that have changed when comparing the target table against the source table in a structured DataTable format.

Removed Rows: Returns the rows that were present in the source table but are missing in the target table in a structured DataTable format

Unchanged Rows: Returns the rows that are identical in both the source and target tables in a structured DataTable format..

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.