Question
TCS
TCS
IN
TCS
Posted: May 2, 2025
Last activity: May 6, 2025
Last activity: 6 May 2025 8:16 EDT
Solved
Deleting list of records in a file
Hi All, I have list of pzinskey's in an xlsx/csv file. My requirement is to read and delete them. Is there any way to do this other than obj-browse or RDB-Delete methods?
***Edited by Moderator Marissa to add Capability tags***
To see attachments, please log in.
Accepted Solution
Posted: 4 weeks ago
Updated: 4 weeks ago
Updated: 6 May 2025 8:16 EDT
Rulesstack Private Limited
Rulesstack Private Limited
IN
Hi @mnkiran1999,
Yes, there are alternative and better approaches for reading and deleting a list of instances (based on pzInsKeys) from an Excel/CSV file Here are some recommended options:
Recommended Approach: Use a Data Page + Activity + File Listener or File Upload
1. Read the file
You can use either:
- File Listener (for background/batch processing), or
- File Upload control in a UI for manual file selection.
2. Parse the file
Use the Parse Delimited Rule (for .csv) or MSOParseExcel activity (for .xlsx), to map records to a pagelist.
3. Iterate and Delete Instances
Create an Activity that:
- Loops through the list of pzInsKeys.
- Uses Obj-Delete-By-Handle method, which is recommended over RDB-Delete.