Deleting rows from a table

The Delete Rows action deletes rows from the selected asset table. You can create a filter to limit the set of rows deleted by the action. If no filter is defined, all rows in the table will be deleted.

Delete rows from an asset table

1. From the Action Type panel, drag the Delete Rows icon onto the canvas. The Delete Rows panel is displayed. If you drag the action onto another existing action, the new action is automatically linked to the existing action. Additionally, the Target Connection and Select Target Table values are automatically populated based on the definition of the action onto which you drop Delete Rows.

2. On the Delete Rows panel, define the action:

   Name – Enter the name of the action. The action name must be unique within the data flow. This name is displayed on the action. The default value is "Delete Rows".

   Connection – Select the database connection where the table for row deletion is located. The connection must already be defined for the data flow.

   Select Target Table – Select the name of the table from which rows will be deleted.

   Cascading Delete – Select this checkbox if you want records deleted from dependent tables.

   When you select Cascading Delete, dependent records based on both required and non-required field values will be deleted. You cannot undo the deletions once you run the action.

   Select Lookup Table(s) – If you are using lookup tables in the action, select the lookup table name. You can type characters in the table name to filter the dropdown selection. You can select one or more lookup tables. As you select tables, they are displayed below the dropdown list. A unique letter is displayed with each table ("A", "B", "C", etc.) for use in table mapping. To remove a lookup table, click the x next to the table name.

   Description – Enter a description to further explain the action. The description is displayed on the action.

3. Click Configure.
4. Define an expression filter to select the records to be deleted from the target table. If you define a filter, a filter icon is displayed on the node.
   If you do not define a filter for the action, all records in the target table will be deleted.
5. Click Apply to save the configuration.

   If you do not want to keep the configuration changes, click Cancel. You are asked to confirm the cancellation. Click Discard to discard any changes to the configuration.

6. Optionally, click Save on the Data Flows page to save the updated data flow draft.