Remove duplicated rows - in selected range

[supermanPunch (Arpan)]

Hi @E.T.S ,

Could you maybe check with the below Post :

Filter DataTable1 by excepting rows from DataTable2 by comparing specific column

give a try at dtResult = (From d in dt1.AsEnumerable Let raf = d.ItemArray.Take(8) Let chk = dt2.AsEnumerable.Any(Function (d2) d2.ItemArray.Take(8).SequenceEqual(raf)) Where not chk Select r =d).CopyToDataTable Assumption: both dts are defining the same datacolumns and its DataTypes no trims needed Empty Filterresult handling:

For your case, we can dynamic the G column number by using the Expression below :

ColumnTake = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("G")

Here, ColumnTake is an integer variable.

Then modifying the Expression in the post we get :

FilteredTable = (From d in dt1.AsEnumerable
Let raf = d.ItemArray.Take(ColumnTake).ToArray
Let chk = dt2.AsEnumerable.Any(Function (d2) d2.ItemArray.Take(ColumnTake).ToArray.SequenceEqual(raf))
Where not chk
Select r =d).CopyToDataTable

Also, to handle the Exception when no rows are filtered we can follow the below :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.AsE…

Note : The assumption is the Headers are not present for the data, hence the Read Range activity Add Headers property are unchecked.