Definition and Usage
This command allows you to delete specific row(s) from a data table. You can choose to delete all rows at once or specify a particular row to be removed from the data table.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Data table | Select an existing data table or create a new one |
| Yes | The data table must exist before deletion |
Delete | Choose whether to delete all rows or a specific row | All rows, Specified row | Yes |
|
Row | Specify the row number. Use 1 for the first row, or -1 for the last row |
| Yes (when "Specified row" is selected) | Positive numbers count from the top; negative numbers count from the bottom |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables for any parameter in this command by clicking on the variable icon or typing {x} where x is your variable name. For example:
You can use a variable to specify which row number to delete
You can reference a data table variable created in previous steps
Notes
Before using this command, ensure that the data table exists and contains data
When specifying a row number, be aware that indexing starts at 1 (not 0)
Using -1 as the row number will target the last row in the data table
If you attempt to delete a row that doesn't exist (e.g., row 10 in a table with only 5 rows), an error will occur
After deleting all rows, the data table structure (columns) will remain intact, only the data is removed