Compare Two Collection



Today I am going to explain how to compare two collections in a Blue Prism Application.

Step 1. Create two dummy excel sheets with some records and few records should be common on both sheets.





Step 2. Open the Blue Prism Application and follow the below steps
  • Create Instance
  • Open Workbook 1
  • Read Workbook 1 Data and store into a Collection 1
  • Open Workbook 2
  • Read Workbook 2 Data and store into a Collection 2



Step 3.
  • Drag and Drop a Loop stage and pass it Data Collection
  • Drag and Drop a second Loop stage and pass it Data Collection 1
  • Drag a Decision stage and check the Condition e.g. [Data Collection.Employee Id]=[Data Collection 1.Employee Id]
  • If condition satisfies then Remove the duplicate records into Data Collection 1 using a Collection VBO and select a Remove Row action.




Still have a doubt, please feel free to place your query.
I will be happy to assist your query.

----------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------
Powered by Blogger.