https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57290#M11318 Hi, I have a process that runs at multiple different times of the day. The process runs at 12pm, 2pm and 3pm daily. The input files are incremented each time the process runs. Eg: 2pm file contains 2pm and 12pm wire transactions, 3pm file contains 12pm, 2pm and 3pm wire transactions, I need to remove transactions that were previously processed. So I need to compare collections are remove duplicate rows. Suggestions welcome. Fri, 28 Oct 2016 15:25:00 GMT john_shiels 2016-10-28T15:25:00Z https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57290#M11318 Hi, I have a process that runs at multiple different times of the day. The process runs at 12pm, 2pm and 3pm daily. The input files are incremented each time the process runs. Eg: 2pm file contains 2pm and 12pm wire transactions, 3pm file contains 12pm, 2pm and 3pm wire transactions, I need to remove transactions that were previously processed. So I need to compare collections are remove duplicate rows. Suggestions welcome. Fri, 28 Oct 2016 15:25:00 GMT https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57290#M11318 john_shiels 2016-10-28T15:25:00Z https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57291#M11319 Input file is excel. Robot loops through initial Input file and stores into a collection. It will then need to loop through next incremented Input file, store into a collection. Then, the robot needs to remove the rows that were in the initial collection. Fri, 28 Oct 2016 17:52:00 GMT https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57291#M11319 john_shiels 2016-10-28T17:52:00Z https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57292#M11320 If the collections are sorted, this is pretty easy - you loop through both simultaneously, and can increment them based on which is further behind, getting rid of the ones that overlap. Doing it this way can even be wrapped up in the single loop through to process the new array; essentially you loop through all recordsf rom the newer file, and skip them if they're also in the older one. -Robin Toll Fri, 28 Oct 2016 18:58:00 GMT https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57292#M11320 RobinToll 2016-10-28T18:58:00Z https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57293#M11321 As with all Blue Prism processes, the expectation is that you are using a Blue Prism work queue as the basis for your work item processing. As you load work into the Blue Prism work queue, you can simply check to ensure a duplicate item has not already been loaded into the queue to be worked - and if it has do not load it into the Blue Prism work queue again. There are examples of loading work into the work queue in one of the Process Examples (distributed in the same portal page as the process templates). Mon, 31 Oct 2016 19:07:00 GMT https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57293#M11321 Denis__Dennehy 2016-10-31T19:07:00Z https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57294#M11322 yes but which actions to be used of VBO or we have to use code stage to achieve this? Thu, 29 Jun 2017 17:29:00 GMT https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57294#M11322 SumitSingh 2017-06-29T17:29:00Z https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57295#M11323 yes but which actions to be used of VBO or we have to use code stage to achieve this? Thu, 29 Jun 2017 17:33:00 GMT https://community.blueprism.com/t5/Product-Forum/Complaring-collectons-and-removing-duplicate-Rows/m-p/57295#M11323 SumitSingh 2017-06-29T17:33:00Z