Hi Naveen,
There are multiple options to do this, even other than the below two options but most of them would be a tedious approach.
Option #1
I have responded to your other post here:
http://www.rpaforum.net/threads/how-to-get-unique-values-from-a-collection.757/post-1872
You can use the same logic to check each of the columns and copy to the output collection only if values of all the 7 columns are matching. This could be time taking particularly if there are large number of rows because we have to check one row at a time, but if you want to use the same logic then you could try and see how long it goes.
Option #2
- Place an excel file with a macro in it which removes duplicates from the sheet data. This macro is a short one and going to be of 3 lines of code including the function start and end. (I can provide you the code if needed)
- Copy the Original collection to an Excel in one shot
- Run the macro on that sheet using the 'Run macro' action of Blue Prism
- The resultant data will have all the dupes removed
- Get the sheet into an Output collection in one shot.
- You can ignore saving the sheet so that each time the file is blank
If you choose to start any of the above options let me know and I can help if you are facing any difficulties.