0 votes
1 view
in RPA by (5.4k points)
recategorized by

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?

1 Answer

0 votes
by (9.5k points)

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

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !