topic Error while using the collection manipulation utility in Product Forum

Error while using the collection manipulation utility

NagababuMaturi — Fri, 08 May 2020 10:36:00 GMT

My requirement take the value from workbook A and search for the value in Workbook B .
1.i have loaded the 2 excel sheets into 2 different collections
2.Taking the value from collection A and searching for the value in collection B using "collection contains value"
3.But it's throwing an error like "could not execute code stage because the value your searching is not available in collection B even the value is available in collection B.

can anyone help me with this .Thanks In Advance.

------------------------------
Nagababu Maturi
------------------------------

RE: Error while using the collection manipulation utility

AlexanderMarlow — Fri, 31 Jul 2020 21:32:00 GMT

Hi Nagababu - are you specifying the field name in the target collection where you are looking for this value?

------------------------------
Alexander Marlowe
Blue Prism
Blue Prism
------------------------------

RE: Error while using the collection manipulation utility

wleung — Fri, 31 Jul 2020 23:12:00 GMT

Hello Nagababu,

I think perhaps the input parameters you are using needs some tweaking. I am including a screenshot with an example below. It is important to send in the right Column Name for the search. My example is using hard coded string but you can add debug statements before the call to ensure you are iterating through the elements in your Collection A as well as specifying the right Column Name as you search through Collection B.

Hope this helps.

------------------------------
Wing Ling Leung
Senior Product Consultant
Blue Prism Professional Services
------------------------------