https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64873#M17577 You could try a code stage with these two lines. The Column_Names input is a collection listing the names you want in the output collection. The code creates an output collection where each row is distinct. Dim v As New System.Data.DataView(Collection_In) Collection_Out = v.ToTable(true, Column_Names.Split("","")) Fri, 08 Dec 2017 14:57:00 GMT John__Carter 2017-12-08T14:57:00Z https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64871#M17575 Hi everybody, I want to delete rows from a collection that are repeated but without have to go through the collection verifying one by one because i have more than 4000 rows so it would be very slow. i hope someone can help me. Thanks! Thu, 07 Dec 2017 21:29:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64871#M17575 Gilberto.lopez 2017-12-07T21:29:00Z https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64872#M17576 Let's assume Collection1 has the data, you need to delete the duplicates from. Create another collection with the data as in Collection 1. Now, create a flow to check each row from Collection1 matches any row in Collection2. If matches, use the action Delete Row. Fri, 08 Dec 2017 07:01:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64872#M17576 SudheerReddy 2017-12-08T07:01:00Z https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64873#M17577 You could try a code stage with these two lines. The Column_Names input is a collection listing the names you want in the output collection. The code creates an output collection where each row is distinct. Dim v As New System.Data.DataView(Collection_In) Collection_Out = v.ToTable(true, Column_Names.Split("","")) Fri, 08 Dec 2017 14:57:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64873#M17577 John__Carter 2017-12-08T14:57:00Z https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64874#M17578 You can use code stage and LINQ query for getting distinct items. way faster than iterating in loop. Tue, 26 Dec 2017 22:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-remove-repeated-Items-from-a-collection/m-p/64874#M17578 JivankumarKedar 2017-12-26T22:40:00Z