extracting different values from two columns

[tim.dauti]

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

[simone.tomaCNH]

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

[tim.dauti]

Hi,

indeed, I ended up creating a code stage.

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

Cheers.

Tim

[simone.tomaCNH]

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