1. Unique Tool – a straight forward method where we just have to select the columns to be unique

1 2

  1. Summarize Tool – by grouping the data, so we can remove the duplicates

q

  1. Tile Tool – by creating a sequence and then filtering the data

4

5

  1. Multi-Row Formula Tool – by ranking the incoming rows and then filtering the data

6

7