Remove duplicates

Remove duplicates activity enables to delete duplicate rows in any columns.


* Excel name	The reference name of the excel file which has already opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in excel can be added. If not added, it is accepted as the first sheet by default.
Row	Indicates on which line the remove duplicate operation will be performed.
Column	Indicates on which column the remove duplicate operation will be performed.

Note: * Fields selected with are required, others are optional.

Excel name example

You can use the Excel name as shown in the example.

newExcel

Sheet name example

You can use the Sheet name as shown in the example.

Sheet1

Row example

You can use the Row as shown in the example.

1

Column examples

You can use the Column as shown in the example .

1

A

Note

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.

In Excel, rows begin with 1, columns begin with 0.

If you want to delete only the column in Excel, the row is left blank.