Hi,
I'm new to both coding and Blue Prism and i'm looking for some support.
I have a a project were I need to compare data from two collections ("Collection_1" and "Collection_2") and pick out any unique rows from "Collection_1" and save in "Collection_3".
Both collections only consists of one column which contains a Service ID.
I've tried with a standard Loop within a loop in BP, but since "Collection_1" and "Collection_2" both consists of over 22000 rows this is too slow.
I've looked around on different forums and it seems that my best bet for speed would be to create a code stage in an object that does this, I could really us some help in creating a code either in VBA or C# to do this.
I know it's a big ask, but any help would be appreciated.
Example:
"Collection_1"
Header: Service ID
4567
4566
4532
3455
9989
4312
"Collection_2"
Header: Service ID
4561
4562
9989
4312
4532
3455
Output:
"Collection_3"
Header: Unique Service ID
4567
4566
I'm new to both coding and Blue Prism and i'm looking for some support.
I have a a project were I need to compare data from two collections ("Collection_1" and "Collection_2") and pick out any unique rows from "Collection_1" and save in "Collection_3".
Both collections only consists of one column which contains a Service ID.
I've tried with a standard Loop within a loop in BP, but since "Collection_1" and "Collection_2" both consists of over 22000 rows this is too slow.
I've looked around on different forums and it seems that my best bet for speed would be to create a code stage in an object that does this, I could really us some help in creating a code either in VBA or C# to do this.
I know it's a big ask, but any help would be appreciated.
Example:
"Collection_1"
Header: Service ID
4567
4566
4532
3455
9989
4312
"Collection_2"
Header: Service ID
4561
4562
9989
4312
4532
3455
Output:
"Collection_3"
Header: Unique Service ID
4567
4566