Forum Discussion

TDys's avatar
TDys
Frequent Visitor
6 years ago
Solved

Remove Duplicates saving one with higer value

Hi    Ho do I remove duplicates for same SERIALID and SAME DATE saving only one with higher SMU value. Table has more than 1000 SERIALID. Some SERIALID do not have double entries.   Thank You in ...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    @TDys

    Here's the entrance.

    image.png

    Here's the exit:

    image.png

    If it helps, mark it as a solution

    Congratulations are also good

VasTg's avatar
VasTg
Icon for Memorable Member rankMemorable Member
6 years ago

@TDys

Here's the entrance.

image.png

Here's the exit:

image.png

If it helps, mark it as a solution

Congratulations are also good

  • TDys's avatar
    TDys
    Frequent Visitor
    6 years ago

    Thank you for super fast help. Appriciare it.

     

    Best regards;

     

    Tomasz