Forum Discussion
Solved
how to remove duplicate
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.
Don't know if there's a quicker way to do this but you can try this:
- Duplicate table - name it Inactive
- Filter the column to only Inactive rows
- Remove duplicate in the table
Then, go back to your primary table:
- Filter the column to only Active rows
- Append the table with the duplicated column
By doing this you should have removed duplicates for only inactive rows
1 Reply
Don't know if there's a quicker way to do this but you can try this:
- Duplicate table - name it Inactive
- Filter the column to only Inactive rows
- Remove duplicate in the table
Then, go back to your primary table:
- Filter the column to only Active rows
- Append the table with the duplicated column
By doing this you should have removed duplicates for only inactive rows