elea mzaet Posted January 9, 2019 Share Posted January 9, 2019 I have data with duplicates rows and I'm looking for a way to remove them automatically. I created a calculated column indicating rows occurrences and I'd like to delete all rows in my table corresponding to the condition: [Rank] != 1. I have this: ------------------------ |ColA ColB Rank |----------------------- | a1 b1 1 | a2 b2 1 | a1 b1 2 | a3 b3 1 | a1 b1 3 | a3 b3 2 And would like to obtain this: ------------------------ |ColA ColB Rank |----------------------- | a1 b1 1 | a2 b2 1 | a3 b3 1 The data source being dynamic, I wonder if there is a way to use a scheduler to perform this task... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now