AX1134
Deleting rows of data as part of an import
To delete rows from a target table during an import, create a transform step that uses the built-in function Delete rows. You can use this function to "clear" a table before importing new data.
NOTE: If you are only updating specific columns in the destination table, then you may want to use a SQL step to zero data rather than using the delete function.
Function parameters
| Parameter | Description |
|---|---|
|
Table |
The name of the table from which to delete rows. |
|
Filter |
Optional. A filter used to identify rows to delete. If omitted, all rows in the table are deleted. The filter can be against the specified table or against a lookup reference table. Standard Axiom filter criteria syntax applies. NOTE: The temp table cannot be referenced in the filter. |
For example, if the table is GL2019, then the filter could be something like:
GL2019.YrMo='{YrMo}'
Where the value of YrMo is defined by an import variable.
Dept.Region='North'
Where the GL2019 table has a column Dept that looks up to the Dept table.
