TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

How to remove duplicate values

In the simplest example, we just want to remove the duplicates based upon one column.

Only the top row from the duplicates will remain, so ensure that you sort the data before.

We can also remove duplicates based upon more than one column. For example, if we want to remove rows with both the same ID and the same Comments: