Filtering repeating values in excel join datatable

Help Studio
, ,
3

Hi @gokul1904
Use following syntax in assign activity and assign this to datatable:
In Assign stage:

Blockquote →
outputDT = inputDT.AsEnumerable.GroupBy(function(r) r(“UnitCost”)).Where(function(r) r.Count() > 1).SelectMany(function(l) l).ToArray().CopyToDatatable