Distinct Function

[rpa_22]

Hello everyone !

I am using:

NewDT = MainDT.DefaultView.ToTable(true,“Product”,“Customer”,“Account”,“Location”)

to get these values distinct datatable, but this function remove other columns.
Is there any other solution which keeps related other columns?

[ppr (Peter Preuss)]

@rpa_22
Welcome to the forum

give a try at following:

Assign activity:
LHS: dtDistinct | datatype: DataTable
RHS:

(From d in YourDataTableVar.AsEnumerable
Let k=String.Join("_", {"Product","Customer","Account","Location"}.Select(Function (x) d(x).toString.Trim))
Group d by  k1 = k into grp=Group
Select r = grp.First()).CopyToDataTable

[rpa_22]

Thanks for quick reply & solution !