Do not display Actions
I want to delete some rows when a condition is met but the data in my table is as follows:
- text column called Item with values such as 1, 1.1, 1.2, 1.2.1 etc. - text column called Root with values such as 1, 2, 3 etc. - a Yes/No column called Invoiced
The table contains: - rows where Root has values such as 1, 2, 3 etc. whose Item column is equal to the Root column value (TOPLEVEL rows) - rows where Item has values such as 1, 1.1, 1.2, 1.2.1 etc. whose Root column value is 1 (CHILD rows)
When the Invoiced column is set to Y for a TOPLEVEL row with a specific Root value, I want to delete all the CHILD rows with the same Root value.
I have defined two actions for this: 1. Delete Child rows - look for corresponding TOPLEVEL row and if it is Invoiced, delete the row 2. Delete Parent row - look for corresponding CHILD rows and if there are none (meaning all CHILD rows have been deleted,) delete the row
My question is, is this a good way to do this and will it work with no explicit action by the user?
Secondarily, as there could be a lot of CHILD rows, I am concerned about speed.
It is easy to create a slice for the CHILD rows - could you consider an action where I can say delete all rows in a slice?