cancel
Showing results for 
Search instead for 
Did you mean: 

Delete specific row from a collection

JustinBishop
Level 4
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

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

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
------------------------------

JahangirKhan
Level 2
Hi,

Try the below DX asset..! Hope this helps..!

https://digitalexchange.blueprism.com/dx/entry/78038/solution/spgmi--utility-collection-booster


Thanks..!

------------------------------
Jahangir Khan
------------------------------