topic Split Collection by row in Product Forum

Split Collection by row

vinodchinthakin — Tue, 08 Nov 2022 09:36:00 GMT

Hi All,

I am looking for a solution to Split a collection by row. For Example I have to split the collection of 15000 records to two collections each with 7500 records.
Do we have any customized code?

------------------------------
vinod chinthakindi
------------------------------

RE: Split Collection by row

ewilson — Tue, 08 Nov 2022 11:47:00 GMT

Hello @vinod chinthakindi,

Take a look at the Utility - Collection Manipulation VBO. It includes a Split Collection action. You can find the latest version on the DX at the link below:

https://digitalexchange.blueprism.com/dx/entry/3439/solution/utility---collection-manipulation

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Split Collection by row

vinodchinthakin — Tue, 08 Nov 2022 12:25:00 GMT

Hi @ewilson. "Split Collection" action from above VBO helps to split collection based on Columns.(predefined in templates)
My requirement is to split collection based on Rows.
I have to split the collection of 15000 records to two collections each with 7500 records. Two collections has same columns.
Could you guide how it can help me.
Thanks!

------------------------------
vinod chinthakindi
------------------------------

RE: Split Collection by row

ewilson — Tue, 08 Nov 2022 12:55:00 GMT

@vinod chinthakindi,

Ah, you are correct. Got ahead of myself. 😳 There are a couple ways you could do this based on rows. You could use the Copy Rows actions to copy the first half of the main collection into a new collection (Start Row = 0, Number of Rows to Copy = 7500) and then call it again with Start Row = 7500, Number of Rows to Copy = 7500).

Alternatively, you could use a Code stage in a VBO to split the underlying DataTable. The following article on Stackoverflow has some examples.

https://stackoverflow.com/questions/34663933/split-datatable-into-multiple-fixed-sized-tables

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Split Collection by row

vinodchinthakin — Tue, 08 Nov 2022 13:57:00 GMT

Thanks Eric for sharing the article. I will give a try.

------------------------------
vinod chinthakindi
------------------------------