topic Supporting joakimeklund. in Product Forum

Delete specific row from a collection

JustinBishop — Mon, 20 Oct 2014 04:53:00 GMT

Is there anyway to tell BP to delete a specific row(s) from a collection other than the first or current row?

No, I'm afraid there's no

StuartWood — Wed, 05 Nov 2014 20:18:00 GMT

No, I'm afraid there's no random access for collections; ie. you can't read from, write to or delete an arbitrary row in the collection.

How do we remove the first

RohithSrinivas — Thu, 03 Aug 2017 11:04:00 GMT

How do we remove the first row ?

You cannot delete, but you

ShreyansNahar1 — Thu, 03 Aug 2017 14:56:00 GMT

You cannot delete, but you can copy specific rows from a collection to another collection using a Collection Manipulation Utility.

You can extend the Collection

Anonymous — Thu, 31 Aug 2017 16:35:00 GMT

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

you can do via code stage.

pramod_a_kumar_ — Tue, 05 Sep 2017 12:02:00 GMT

you can do via code stage.

Depends on details, but you

JiriPospisil — Tue, 05 Sep 2017 15:55:00 GMT

Depends on details, but you could probably use 'Filter Collection' action in 'Utility - Collection Manipulation' BO. Filter would be something like ""Field 'valueyoudontwanthere'"", as Output select same collection as input and there you go.

Do you know before hand what

joakimeklund — Mon, 11 Sep 2017 10:52:00 GMT

Do you know before hand what rows to delete you could just loop the collection with a counter and in a decision stage delete the row when the counter reaches the specific number.

Supporting joakimeklund.

ivan.gordeyev — Mon, 11 Sep 2017 14:14:00 GMT

Supporting joakimeklund. This is by far the best method. When you establish which row needs to be deleted. - Start a loop; - Everytime a loop runs add 1 - When Row to be deleted is the row of the loop, use object - Internal - Collections - Action Remove Row.

RE: Delete specific row from a collection

Tejaskumar_Darji — Wed, 08 Sep 2021 09:27:00 GMT

If you wanna remove rows without any logical condition then this solution can help.

Let's say you wanna keep only 1st row and remove all other rows OR you wanna keep the first 5 rows, 10 row,s etc any number of rows that you're sure of,

Using the Copy Rows action, you can pass start row and from there how many rows you wanna copy. So in the above example, it will keep only the first row and remove all others.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: Delete specific row from a collection

stelabentley — Tue, 14 Sep 2021 22:03:00 GMT

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

RE: Delete specific row from a collection

michaeloneil — Wed, 15 Sep 2021 10:40:00 GMT

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

RE: Delete specific row from a collection

JahangirKhan — Wed, 15 Sep 2021 15:03:00 GMT

Hi,

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

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

Thanks..!

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