Make data have a unique field

Question

My data does not have any duplicate rows, however one field has values which appear multiple times. How can I discard rows where this value appears multiple times? In the end I just want one row for each value in this field, I can keep any one of the rows that is in my data.

i.e. Row 1: a=1, b=2; Row 2: a=1, b=3; Row 3: a=1, b=4; I just want to keep and one of Row 1-3 as I only need a=1 in my data once (regardless of what b is).

Thanks!

ShankerV · Answer

@monilpatel89

One way of doing this is.

In the union tool configuration, please check only the Column A to fetch the unique record.

Many thanks

Shanker V

Make data have a unique field.yxmd

flying008 · Answer

Hi, @monilpatel89

You only need use unique tool to field [a]:

******

If it can help you , please mark it as a solution and give a like for more share.