Filter and remove duplicates

Hi All,

I have a file. Column A has all employee IDs and it has duplicate IDs since data is consolidated for different dates into one file. Now my requirement is to filter the data as per employee ID and remove the duplicates based on value in a different column. So I will put a filter in Column A and check the the values in Column G and remove the entire row if column G has duplicate value. Appreciate any help around this.

Thanks in Advance!

Common Use Cases

Accepted answers

EricaR

Hello Hermant86,

If I understand your use case correctly you should be able to use the unique tool. Configure it to identify a duplicate using both the ID column as well as the additional column. If this is an incorrect assumption of what you would like to accomplish please post a small sample of the data and identify a few "duplicates" and I can try again.

All comments

EricaR

Hello Hermant86,

T_Willins

Hi @hemant86,

The solution @EricaR recommended is correct. A Unique tool with the Column Names "Person:System ID" and "Notes" selected will return your required output data.

EricaR

Yes that is what I was expecting. The unique tool (in preparation) should get the job done for you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703