Excel read out and filter by two columns

[nina.wenner]

Hi,

I need your help again.

I would like to have all transactions where the value from the Reference and Supplier columns are identical.

exampl.:

I need a DataTable only with this references

Tanks
Nina

[Anil_G (Anil Gorthi)]

@nina.wenner

please use this in assign

dt = dt.AsEnumerable.GroupBy(function(x) x("Reference").ToString+x("Supplier").ToSTring).Where(function(x) x.Count>1).SelectMany(function(x) x).CopyToDataTable

cheers

[Shiva_Nikhil]

@nina.wenner

dt1.AsEnumerable.GroupBy(function(a) Tuple.Create(a(0).tostring,a(1).ToString)).where(Function(grp) grp.Count>1).SelectMany(function(grp) grp).copytodatatable

you can also try in this way

[ppr (Peter)]

Assign activity
dtResult | DataTable =

(From d in YourOrigDataVar.asEnumerable
Group d by k1=d("Reference").toString.Trim, k2=d("Supplier").toString.Trim into grp=Group
Where grp.Count > 1
From g in grp
Select r=g).CopyToDataTable

Handling Empty results:
[FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

[nina.wenner]

@Anil_G

AsEnumerable.GroupBy(function(x) x(“Reference”).ToString+x(“Supplier”).ToSTring).Where(function(x) x.Count>1).SelectMany(function(x) x).CopyToDataTable

@Anil_G thank you very much it’s working.