Forum Discussion

rippernash's avatar
rippernash
New Member
4 years ago
Solved

Remove duplicates and keep only last revision

I have the below data in the first table "Current Data" that has duplicates. The duplicates are in the column "Name" but each value has a unique Part number in the "Part number" column. I want to be ...
Need Help
Tips and Tricks
Tutorial Requests
  • davehus's avatar
    davehus
    4 years ago

    Hi rippernash ,

     

    Please see solution below. If you step through it you can see how it's done.

    Split Revision Number to get letter

    Sorted by Part asc and then then revision letter descending.

    Group by and created and index by each part number.

    Filtered to 1.

     

    You may need to tweak to suit your data but it gives you something to work off.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi rippernash ,

 

Please see solution below. If you step through it you can see how it's done.

Split Revision Number to get letter

Sorted by Part asc and then then revision letter descending.

Group by and created and index by each part number.

Filtered to 1.

 

You may need to tweak to suit your data but it gives you something to work off.

 

Did I help you today? Please accept my solution and hit the Kudos button.