how to remove duplicate

[Ramendra]

Hi All,

How to remove duplicate if I want to choose which one should be kept and which one should be removed.

I have duplicate values of asset serial number but thier status is different.
One status is disabled and another is  active for same serial number.

I want to remove that serial number as duplicate which is not in active state.

[darentengmfs · Accepted solution]

@Ramendra 

Don't know if there's a quicker way to do this but you can try this:

1. Duplicate table - name it Inactive
2. Filter the column to only Inactive rows
3. Remove duplicate in the table

Then, go back to your primary table:

1. Filter the column to only Active rows
2. Append the table with the duplicated column

By doing this you should have removed duplicates for only inactive rows