Man illustrationFlower illustration

Docy

Remove duplicates

Estimated reading: 1 minute 87 views

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


*Excel nameReference name of Excel which will be opened.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
RowIndicates on which line the Remove duplicate operation will be performed.
ColumnIndicates on which Column the Remove duplicate operation will be performed.
Note: * Fields selected with are required, others are optional.

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

newExcel

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

Sheet1

You can use the Row as shown in the example.

1

You can use the Column as shown in the example.

1

A

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.

CONTENTS