topic Re: extracting different values from two columns in University Forum

extracting different values from two columns

tim.dauti — Tue, 28 Oct 2025 16:19:40 GMT

Hello everyone,

I am trying to deal with 2 collections which most of the cases will have same nr of column and same naming.

Sometimes it might be that one of the collection has few more columns.

I would like to identify the extra columns.

In order to achieve that I am using collection manipulation "Get collection fields". (For the first and second collection)

Than Looping "fileds Col1" and checking in "Fields col2" if the field is there and viceversa.

This looping logic works but it is slow as my collections have more than 200 Columns.

Here a screenshot that shows better : (Goal is to get the yellow marked values as output)

Thank you for your help

Kindly

Tim

Re: extracting different values from two columns

simone.tomaCNH — Tue, 28 Oct 2025 17:10:17 GMT

Hi,

You can extend the Collection Manipulation object with code written in Visual Basic and extract a collection with the missing columns from the collection you decide to loop through. The loop executed via code (whether Visual Basic or C#) is definitely faster than Blue Prism's internal loop.

Simone

Re: extracting different values from two columns

tim.dauti — Wed, 29 Oct 2025 13:15:35 GMT

Hi,

indeed, I ended up creating a code stage.

Would be nice to have some more features in Collection Manipulation.

Cheers.

Tim

Re: extracting different values from two columns

simone.tomaCNH — Wed, 29 Oct 2025 13:33:45 GMT

Hi Tim,

All actions within the Collection Manipulation object are code stages, so you can consider extending the object itself or creating a copy with additional actions.

Simone