Remove Duplicates Range

This activity allows the user to remove duplicate rows from the specified range of cells in the sheet. It functions within the “Excel Scope” activity.

Properties

INPUT

SheetName: *Specify the “SheetName” where the duplicate rows to be removed, and it accepts values in “String” datatype. 

Range: *Specify the “Range” from the specified sheet, and it accepts values in the “String” datatype. 

MISC

DisplayName: 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

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.