Comparing Collections with different number of columns

aanchalm — Thu, 25 May 2023 04:10:00 GMT

Hi,

I have two collections, coll A and Coll B, CollB has all the columns of coll A and an additional column "Result", Now the problem is I have to compare the collections and find out the unique values from them and write thrm in another collection.

------------------------------
A S
------------------------------

RE: Comparing Collections with different number of columns

harish.mogulluri — Thu, 25 May 2023 16:13:00 GMT

HI As,
I assume you dont want the other additional column present in the collection B?
Multiple ways you can get the values
1) Merge both the collection ( If you have the same columns) and get unique values
2) Loop the collection A and check the collectionB contain value if it is True then add the row in the new collection
3.) Check this thread for Inner Join:
https://community.blueprism.com/viewdocument/re-comparing-collections?CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=librarydocuments?utm_source=blueprism&utm_medium=pweb&utm_campaign=gl-web-2022-q1-12-3-community-related-discussions
4) Write Code stage ( C# or vb.net):
VB.Net:
INput parameters: I_Collection_B, I_Collection_B
Output parameters: O_Collection

O_Collection = I_Collection_A.AsEnumerable().Intersect(I_Collection_B.AsEnumerable(),DataRowComparer.Default).CopyToDataTable()

In the initailize action under code option make sure the external references and Name spaces are present:
External reference:
System.Core.dll
System.Data.DataSetExtensions.dll
NameSpaces:
System.Data.DataSetExtensions

Check some other useful articles
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/comparing-datarows-linq-to-dataset
https://social.msdn.microsoft.com/Forums/en-US/cb8ef7f7-5e7f-4448-9181-4111942b1a7c/how-to-compare-two-data-tables-and-create-a-new-data-table-based-on-the-compared-results-c?forum=aspwebformsdata
https://stackoverflow.com/questions/11862113/how-to-compare-2-datatable-and-get-unique-records-in-3rd-datatable
System.LINQ

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------

topic Comparing Collections with different number of columns in Product Forum

Comparing Collections with different number of columns

RE: Comparing Collections with different number of columns