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, then check the checkbox Remove the older rows and preserve the newest.

Do Not Place Inside Loops

This is a batch operation. This means that all data table rows - no matter how many there are - are fetched and the duplicate removal is applied to the whole data 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