Delete Rows of Data in a Table

Security:

Prism: Manage File Containers
domain in the Prism Analytics functional area when uploading a file.

Any of these security requirements:

Prism: Tables Owner Manage
domain in the Prism Analytics functional area.

Prism: Tables Manage
domain in the Prism Analytics functional area.

Table Owner
permission on the table.

Table Editor
permission on the table.

Can Delete Table Data
permission on the table.

Can Truncate Table Data
permission on the table.

You can delete a subset of rows in a table using these methods:

Row Deletion Method	Notes
By load ID	You can quickly delete all rows that came from a particular data load activity. Select Table Delete Rows from the related actions menu of the table. Then select Previous Loads .
By data change task	You can delete specific rows that you specify using a data change task with the delete operation. You delete rows by specifying one these target fields as the Delete Key : The field configured as the external ID WPA_LoadID WPA_RowID To delete rows using a data change task, you need a delimited file that contains a single field that contains the values in the delete key field. Example: You can delete the rows for particular values of the field configured as the external ID. Create a CSV file that contains the values of the external ID field you want to delete. To delete some rows from the ClaimID field, your CSV file might look like: ClaimID 345999 345600 345601 345602

Row Deletion Method

Notes

By load ID

You can quickly delete all rows that came from a particular data load activity. Select

Table

Delete Rows

from the related actions menu of the table. Then select

Previous Loads

By data change task

You can delete specific rows that you specify using a data change task with the delete operation.

You delete rows by specifying one these target fields as the

Delete Key

The field configured as the external ID

WPA_LoadID

WPA_RowID

To delete rows using a data change task, you need a delimited file that contains a single field that contains the values in the delete key field. Example: You can delete the rows for particular values of the field configured as the external ID. Create a CSV file that contains the values of the external ID field you want to delete. To delete some rows from the ClaimID field, your CSV file might look like:

To delete specific rows using a data change task:

Access the

View Table Details

report for the table to delete from.

Select

Quick Actions

Data Change Task

(Optional) Change the data change task name that Workday created automatically at the top of the left side panel.

On the

Source

step, select the file that contains the values of the rows you want to delete.

On the

Source Options

step, define how to parse the data in the files.

On the

Target

step, select

Delete

as the

Target Operation

On the

Mapping

step, select a field in the target table to use as the

Delete Key

Select a source field for the target field that you specified as the delete key.

Concept: Data Change Tasks

Create a Data Change Task