Do not display Actions I want to delete some...

[Bellave_Jayaram]

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?

@Adam_Stone @Aleksi_Alkio @praveen