Remove Duplicates

This action removes all the rows that are duplicate.

It is best practice to always specify a column, unless you have a very special case. Specifying a column will make your TaskBot run faster.

Notes: Files in file columns will be ignored when searching for duplicates.

The TaskBot will remove the latest (the newest) rows and preserve previous rows per default. If you want to reverse this behavior, then check the checkbox Preserve newest rows (note that this option is only available in native tables and not available for Google Sheets).

Do Not Place Inside Loops

This is a batch operation. This means that all table rows - no matter how many there are - are fetched and the duplicate removal is applied to the whole table. Hence, it does not make sense to use this on every loop iteration.

If you place this building block inside a loop, duplicates will only be removed once.

Video Tutorial