Delete specific row from a collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
20-10-14 05:53 AM
Is there anyway to tell BP to delete a specific row(s) from a collection other than the first or current row?
12 REPLIES 12
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-09-21 11:03 PM
You can extend the Collection Manipulation Utility and add a code stage to delete a specified row.
Try duplicating an action like Copy Row where you need to supply an index and change it,
placing a collection.Rows(index).Delete() somewhere and output a new collection
--------------------------
Optics4birding
Try duplicating an action like Copy Row where you need to supply an index and change it,
placing a collection.Rows(index).Delete() somewhere and output a new collection
--------------------------
Optics4birding
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-09-21 11:40 AM
Hi
You can delete rows which aren't the first or last row you just need to loop through the collection until you find the row you need to delete. Of course this assumes you have a way of identifying the row required to be delete using some criteria. Use the object in Internal Business Objects - Collections and action Remove row. The input is the collection name where the row is to be removed but it doesnt allow you to enter the row number or anything so it will delete whatever row your collection is currently on. If your ok with coding you could make a copy of this action and then amend it to accept a row number but if you are ok with using a loop to get the correct row then this will work fine for you.
------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------
You can delete rows which aren't the first or last row you just need to loop through the collection until you find the row you need to delete. Of course this assumes you have a way of identifying the row required to be delete using some criteria. Use the object in Internal Business Objects - Collections and action Remove row. The input is the collection name where the row is to be removed but it doesnt allow you to enter the row number or anything so it will delete whatever row your collection is currently on. If your ok with coding you could make a copy of this action and then amend it to accept a row number but if you are ok with using a loop to get the correct row then this will work fine for you.
------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-09-21 04:03 PM
Hi,
Try the below DX asset..! Hope this helps..!
https://digitalexchange.blueprism.com/dx/entry/78038/solution/spgmi--utility-collection-booster
Thanks..!
------------------------------
Jahangir Khan
------------------------------
Try the below DX asset..! Hope this helps..!
https://digitalexchange.blueprism.com/dx/entry/78038/solution/spgmi--utility-collection-booster
Thanks..!
------------------------------
Jahangir Khan
------------------------------

- « Previous
-
- 1
- 2
- Next »