The unique tool allows you to remove duplicate records in a data set, or remove duplicate values in a column. Let's start a new workflow and import spreadsheet 2.7 we'll go to the end out tab, drag in the input data tool and select 2.7 unique. Here we have our HR file again, but instead of the 30 employees, we have 123456 employees that have been duplicated. To make sure we have a unique set of employees. Let's go to the preparation tab and drag in the unique tool into our workflow. You will notice that the unique tool has two outputs, one for you or unique and one for D called duplicate the you receives all the unique records and D receives all the duplicate records In the configuration pane on the left, we want unique records only, so we have to select all fields in this list here.

However, if we wanted only unique values in a column, then you would just select that unique field and run the workflow. But we want everything in this instance. So let's run our workflow or press Ctrl R. And you can see that with you, we have our six unique employees and D receives the duplicates