topic RE: Updated Collection Manipulation VBO Released! in Digital Exchange

Updated Collection Manipulation VBO Released!

ewilson — Fri, 11 Nov 2022 21:49:00 GMT

All,

A new version of the Utility - Collection Manipulation VBO has been released on the Digital Exchange. You can find the latest VBO at the following link:

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

The new VBO includes 3 new actions:

Get Matched Records - This action returns the records that exist in both input Collections.
Get Union of Collections - This action returns the union (a combined Collection of unique records) of the two input Collections.
Get Unmatched Records - This action returns the records from the first Collection that do not exist in the second Collection.

NOTE: The Collections must have the same column definitions in all three actions.

We hope you find these actions useful.

#UpdatedAsset #DigitalExchange

Cheers,

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

RE: Updated Collection Manipulation VBO Released!

Nandita_r — Wed, 24 Jan 2024 15:59:00 GMT

Hi @Eric Wilson

I have imported the updated Collection Manipulation VBO, but it shows 12 errors shown as below, as I wanted to use Get Matched Records Action.

I have also added the Dll files as in the other SS.

Can you please suggest solution for this.

Thanks and Regards

------------------------------
Nandita R
RPA Developer
Qualesce India Pvt Ltd
Bangalore Karnataka
------------------------------

RE: Updated Collection Manipulation VBO Released!

ewilson — Wed, 24 Jan 2024 18:27:00 GMT

@Nandita R,

What version of Blue Prism are you using?

Cheers,

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

RE: Updated Collection Manipulation VBO Released!

Nandita_r — Thu, 25 Jan 2024 04:15:00 GMT

Hi @Eric,

I was using the latest version 7.3, I am aware that it is a beta version but wanted to explore new addon's.

I found that Utility is working fine in Blueprism 7.0v.

Thanks and regards,

------------------------------
Nandita R
RPA Developer
Qualesce India Pvt Ltd
Bangalore Karnataka
------------------------------

RE: Updated Collection Manipulation VBO Released!

ewilson — Thu, 25 Jan 2024 15:43:00 GMT

@Nandita R,

I'm not sure what you mean by "beta version"? BP v7.3 is GA and that's the release I'm using (specifically the true 64-bit version). Your list of DLLs is slightly different from the version on the DX. This is a screenshot of fresh download from the DX, and this does not show any errors when compiled in my BP v7.3.

You want to get rid of the System.Linq.dll reference in the External References list.

Cheers,

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

RE: Updated Collection Manipulation VBO Released!

Nandita_r — Mon, 29 Jan 2024 10:51:00 GMT

Hi @Eric Wilson

I am using the Blueprism Trial Version 7.3, All the dll files are same as yours but it still shows the error as I posted Earlier,

Is it because it's the trial version that I am using?

Can you please suggest any solution,

Thanks,

------------------------------
Nandita R
RPA Developer
Qualesce India Pvt Ltd
Bangalore Karnataka
------------------------------

RE: Updated Collection Manipulation VBO Released!

ewilson — Mon, 29 Jan 2024 16:08:00 GMT

@Nandita R,

Did you remove the reference to System.Linq.dll as I suggested? We utilize the System.Linq namespace, but we use the one that's part of System.Core.dll. By including the System.Linq.dll reference, you're referencing the wrong version of the namespace.

Cheers,

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

RE: Updated Collection Manipulation VBO Released!

Nandita_r — Tue, 30 Jan 2024 03:55:00 GMT

It Worked!!

Thanks @Eric

------------------------------
Nandita R
RPA Developer
Qualesce India Pvt Ltd
Bangalore Karnataka
------------------------------

Re: Updated Collection Manipulation VBO Released!

UAMudrykIh — Mon, 28 Apr 2025 08:17:55 GMT

Hello @ewilson, I have a question about "Get Unmatched Records" action. What about the scenario when all the values from first collection exist in the second collection? I get this error in that scenario: "ERROR: Internal: Could not execute code stage because exception thrown by code stage: The source contains no DataRows."
Should I go with Recover-Resume in that case? Or what would be the best approach to handle this?

Re: Updated Collection Manipulation VBO Released!

ewilson — Mon, 28 Apr 2025 14:30:03 GMT

Does your collection actually have any rows in it or just column definitions? The exception indicates there are no rows of data.

We should actually catch that specific error and raise a better one I think.

Cheers,
Eric

Re: Updated Collection Manipulation VBO Released!

UAMudrykIh — Mon, 28 Apr 2025 14:40:25 GMT

Yes, both of my collections have rows. I have tested it, and this error occurs specifically when all of the values from 1st collection exist in the second. Here is the example I used. The first screenshot is the main collection and the second is the comparison one.I found this solution c# - How to fix "The source contains no DataRows"? - Stack Overflow, it might be useful

Re: Updated Collection Manipulation VBO Released!

ewilson — Mon, 28 Apr 2025 17:01:33 GMT

@UAMudrykIh we're making a change to the VBO to capture the exception internally and return an empty collection in the case where there's no match. Should be posted to the DX today.

Cheers,
Eric

Re: Updated Collection Manipulation VBO Released!

ewilson — Mon, 28 Apr 2025 17:15:47 GMT

@UAMudrykIh updated VBO is now available on the DX.

https://digitalexchange.blueprism.com/cardDetails?id=115158

Cheers,
Eric