Compare collection

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

Properties

Input

Compare Mode: Specifies how the rows in the collection are compared during matching or lookup operations.

• Key comparison: Compares only the keys.

• Value comparison: Compares only the values.

• Key-Value pair comparison: Compares both the key and its corresponding value together.

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

First collection*: Specifies the source collection that contains the values to be matched.

Second collection*: Specifies the target collection 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

Only In Second: Returns the rows that exist in the second collection but not in the first collection in a structured collection format.

Only in First: Returns the rows that were present in the first collection but are missing in the second collection in a structured collection format

Common items: Returns the rows that are identical in both the first and second collections in a structured collection 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.