Removing duplicates based on multi columns

fomenter

I have a set of records and so would like to remove duplicate ones (based on all 3 columns)

Product Name	Product Name	Assignment Number
ABC	12	SE TA
ABC	23	SE TA
ABC	12	SE TA
ABC	12	SE TB
DS AS	11	ASAS
DS AS	11	ASAS
DSAS	12	ASAS

After removing duplicates

Product Name	Product Name	Assignment Number
ABC	12	SE TA
ABC	23	SE TA
ABC	12	SE TB
DS AS	11	ASAS
DSAS	12	ASAS

RodL

Not sure I understand your followup question, but the best way to understand a tool is to test and play with it.

I've attached an example workflow with your data so you can see what comes out the two anchors. Based on your original question, it does what you want.

Again, read through the Help article on the Unique tool. You can also go to Help > Sample Workflows > One-tool Examples > Preparation > Unique where there is an example of how to use the tool wtih some use case examples.

Unique Example.yxmd