topic Collection Manipulation in Product Forum

Collection Manipulation

jebarson — Mon, 26 Oct 2020 17:37:00 GMT

How to split a collection based on the number of rows ?

------------------------------
Jane Jebarson Senior Automation Engineer
Engineer
Allianz
Europe/London
------------------------------

RE: Collection Manipulation

PatrickAucoin — Mon, 26 Oct 2020 17:48:00 GMT

Look at the Collection Manipulation utility, Copy Rows action. Provide the input collection, start row, and number of rows to copy, and it will copy the specified rows into a new collection.
To split a collection by number of rows, you could use this action multiple times. Also, the internal Collections object has a Count Rows action that may be useful to get the total number of rows in the collection.

#Collections

------------------------------
Patrick Aucoin
Senior Product Consultant
Blue Prism
------------------------------

RE: Collection Manipulation

jebarson — Tue, 27 Oct 2020 08:15:00 GMT

Thanks for the update. It worked.

------------------------------
Jane Jebarson Senior Automation Engineer
Engineer
Allianz
Europe/London
------------------------------