Collection Data manipulation Blue Prism: Calculation stage - and split into two collections based on the result

Question

I am currently working on a Collection that has the data of a reconciliation Excel report (accounting). Since there are apprx 1500 rows, looping through the collection takes quite some time.

I'd rather do a code stage that does the calculation, mainly looking to see if there is a difference between two of the rows. All The rows with a difference between the two lines should be exported to a new collection. Has anybody done anything similar either in C# or VB.script?

Answer 1

I suggest you use object: utility- collection manipulation.

Action: filter collection.

As an input collection use the collection you retrieved from the Excel file and as a filter express use this:

[ub_hovedbok] <> [ub_bank]

This will output a new collection with rows only with values different in those two columns