Delete with formula
Function¶
This operations allows you to delete the rows present in the target dataset using an SQL formula.
It is therefore necessary to specify the SQL formula that identifies the data to be deleted.
To make the operation parametric, AW parameters can be used. (see page AW Parameters).
If the Dataset is :
Dataset¶
| Category | Product | Price | Currency |
|---|---|---|---|
| Electronics | Smartphone | 699 | USD |
| Fashion | Sneakers | USD | |
| Home | Coffee Maker | 89 | USD |
| Toys | Puzzle Game | USD |
Example
Formula specified on the operation page¶
PRODUCT LIKE 'S%'
The operation deletes the rows that comply with the formula.
The data processing ends and the rows of the dataset are:
| Category | Product | Price | Currency |
|---|---|---|---|
| Home | Coffee Maker | 89 | USD |
| Toys | Puzzle Game | USD |