Jump to content
We've recently updated our Privacy Statement, available here. ×

Remove automatically rows based on a condition


elea mzaet

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...