Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Deleting data records in bulk

Updated on April 6, 2022

To remove data records more quickly, make your changes in bulk by importing a .csv file.

  1. Upload the file.
    1. In the navigation pane of App Studio, click Data.
    2. Click a data object.
    3. Click the Records tab, and then click Import.
    4. In the Purpose list, select Delete.
    5. Click Choose File.
    6. Navigate to your .csv file, and then click Open.
    7. Click Next.
  2. Map a column in your file to the key field in the data object.
    For example, your file may identify employees by Staff ID but your data object stores this information in the Employee ID field. If your data object has multiple key fields, repeat the following steps for each field.
    1. In the Match existing records by field, press the Down Arrow key, and then select the column in your file that uniquely identifies each data record.
    2. Click Select, and then double-click the field in the data object that corresponds to the column.
      Tip: To narrow the list of fields, enter text in the Search field, and then click outside the field.
  3. Click Next.
  4. Click Import.
  5. If there are failures displayed in the Current import statistics section, resolve them.
    1. Click Download.
    2. Follow the instructions in the .csv file to fix the rows that have errors.
    3. Close the Import progress dialog box, and then retry the import process with your updated file.
  6. Click Finish.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us