The ‘Find Duplicates’ task is searching and extracting duplicate substrings in records of a table column.
The ‘Find Duplicates’ task is very powerful to e.g. clean up long list of data. If e.g. a creditor list contains various items of similar but not the same substrings, like ‘Miller Ltd.’, ‘Miller & Co. Ltd.’, ‘Miller & Co.’, the task extracts Miller as common substring of all three items and Miller & Co. as common substring of the latter two. This allows to easily clean-up data lists.
Go to Flow Gallery and Copy & Edit the Find Duplicates Flow for example usecases.