Skip to main content
Workday User Guide
Last Updated: 2023-11-03
Truncate Data in a Dataset

Truncate Data in a Dataset

Any of these security requirements:
  • Prism Datasets: Manage
    domain in the Prism Analytics functional area.
  • Dataset Editor
    permission on the dataset.
  • Dataset Owner
    permission on the dataset.
You can remove the data in a base dataset by truncating the dataset. Truncating a dataset removes the data from the dataset, but retains its metadata, such as schema and transformations.
You might want to truncate a base dataset if:
  • The dataset integration uses Append mode and after several integrations the dataset contains some bad data.
  • The dataset contains data that your organization later deems to be sensitive.
If you've previously published this dataset or a derived dataset based on this dataset, the associated Prism data source still contains data. If you also want to remove the data from the associated Prism data source, then you must publish the dataset again. Publishing a truncated dataset makes the associated Prism data source empty, but active.
If you're new to Workday, you don't have access to create or edit base datasets.
  1. Access the
    View Dataset Details
    report for the dataset you want to truncate.
  2. Select
    Actions
    Dataset
    Truncate
    .