Support Article
Removed records from Excel not deleted from table after import
SA-60971
Summary
Data is exported to an Excel file using the Data Table wizard. Some records are deleted from the exported file and imported back to the same data table using the Import wizard.
In Pega 7.1.9, the records removed from the Excel by the Import wizard, are deleted in the data table after the import. However in Pega 7.3.1, the removed records from Excel are not deleted from the data table after the import.
Error Messages
Not Applicable
Steps to Reproduce
- Export a file from the data table.
- Delete a row.
- Import the file to the data table. Verify if the deleted row is present in the data table.
The expectation is that the deleted row is removed from the data table.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Perform the following local-change: Click the icon in Designer Studio to switch to Pega Express
- Click Data.
- Click the data type.
- Click the Records tab.
- Export to CSV.
- Modify the results (add records, remove records, delete records).
- Import the CSV from Pega Express using the old Import wizard.
Published March 30, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.