Hi all,
I know this was somewhat answered via https://www.rpaforum.net/threads/comparing-two-collections-and-and-saving-unique-values.14717/
But I would like to see if there is a way to further narrow down a comparison using code stage for Blue Prism.
The given code is the following: Collection_3 = Collection_2.AsEnumerable().Except(Collection_1.AsEnumerable(), DataRowComparer.Default).CopyToDatatable()
While the code for the collection comparison works when it comes to handling just 1 field within each of the collections. If we are to compare collections that have 2 or more fields, due to the current logic, it would compare between all fields to find unique values.
Is there a way to add onto the coding where we are comparing just 1 specific field between two collections to get unique values?
Ex:
Collection 1 & 2 have fields: Street & Votes
What I am trying to get is just unique values from the field Street only.
I know this was somewhat answered via https://www.rpaforum.net/threads/comparing-two-collections-and-and-saving-unique-values.14717/
But I would like to see if there is a way to further narrow down a comparison using code stage for Blue Prism.
The given code is the following: Collection_3 = Collection_2.AsEnumerable().Except(Collection_1.AsEnumerable(), DataRowComparer.Default).CopyToDatatable()
While the code for the collection comparison works when it comes to handling just 1 field within each of the collections. If we are to compare collections that have 2 or more fields, due to the current logic, it would compare between all fields to find unique values.
Is there a way to add onto the coding where we are comparing just 1 specific field between two collections to get unique values?
Ex:
Collection 1 & 2 have fields: Street & Votes
What I am trying to get is just unique values from the field Street only.