topic RE: Is there a method to get a field in a collection by index without using Loop? in Digital Exchange

Is there a method to get a field in a collection by index without using Loop?

Digital_WorkerB — Sat, 21 Sep 2019 20:01:00 GMT

I'm new in BluePrism, I have a collection named ToDate, and it had 1 column named Column1, i want to get the value of the second row, so i try [ToDate.Column1.Row(2)] and it doesn't work, What can i do?

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by Medbouk.

RE: Is there a method to get a field in a collection by index without using Loop?

GeoffHirst — Sun, 22 Sep 2019 11:59:00 GMT

Hi Medbouk,

Thank you for using Blue Prism.

Please take a look at our Digitial Exchange area (DX), there is a VBO called Utility - Collection Manipulation. This provides a lot of extra functionality for working with collections. You should be able to find it here. https://digitalexchange.blueprism.com/dx/entry/9648/solution/blue-prism-collection-manipulation

You will need to sign up to the DX if you aren't already a member.

I hope this helps, please come back to the forum if you need anything else.

regards

Geoff Hirst
Consultant
Partner Integrations for the Digital Exchange.

------------------------------
Geoff Hirst
Partner Pre Sales
Blue Prism
------------------------------

RE: Is there a method to get a field in a collection by index without using Loop?

raviteja0612 — Sat, 21 Nov 2020 16:51:00 GMT

Try to filter your collection with some criteria and result of it is your value in Row 1 of 1

------------------------------
raviteja chintala
------------------------------

RE: Is there a method to get a field in a collection by index without using Loop?

zdenek.kabatek — Mon, 23 Nov 2020 22:19:00 GMT

Hi,

to make it even more explicit as Geoff wrote you need to use Utility - Collection Manipulation VBO. There is an action Read Collection Field. You need to enter values for Input and Output (to get the value) tabs. See two screen shots below.

Regards,

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

RE: Is there a method to get a field in a collection by index without using Loop?

ManasKarlekar — Tue, 23 Aug 2022 12:20:00 GMT

What should be done if the row index is variable(i.e there are multiple rows in the collection) ?
We cannot hardcode the row index value in that case.

------------------------------
Manas Karlekar
------------------------------

RE: Is there a method to get a field in a collection by index without using Loop?

GeoffHirst — Tue, 23 Aug 2022 12:34:00 GMT

Hi Manas,

Thank you for using Blue Prism and for being a SSC Blue Prism customer.

It sounds like what you require is the ability to address the rows/columns of a collection as a grid? Would that be a fair statement?

If so, you may need to consider using a code stage to read the collection data into a 2-dimensional array and process the data this way. Alternatively, you may be able to create a class that matches the signature of your collection row and create a generic list using that class.

I am interested to understand why you are unable to use a loop, given that collections are usually aimed at being processed inside of loop constructs.

Please come back to us if you are unable to resolve your problem or need further assistance.

Once again, thank you for being a SSC Blue Prism customer and for using Blue Prism.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: Is there a method to get a field in a collection by index without using Loop?

GeoffHirst — Tue, 23 Aug 2022 12:37:00 GMT

Manas,

As an aside from my previous comment, you could use a data item as a number iterator and that could act as your collection index, you can then freely update that using a calculation stage.

Does this help?

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------