This Node (selectively) deletes records from the current Data Table.
If no Rules are in place this Node will delete all the current records. You can restrict this to only delete records that match certain criteria by double-clicking on the Node in your Task and specifying which rules should apply:
Let's imagine we need to create a sales report identifying under-performing regions. We want our report to include regions where the quarterly turnover has been less than the average for the entire company. Our initial data table (which we'll create with the Create Data Table node) contains the following:
We can then calculate the average turnover using the "Calculate Column Aggregate" node. Following this, a "Drop Rows" node removes any rows which match the condition:
And here is the resulting Data Table, which only contains records where the turnover is below the average (£ 67,530.00}: