Make data have a unique field

[monilpatel89]

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!

[flying008]

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.

[ShankerV]

@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