How to get unique column values from my data table

Help Studio
, ,
1

input:
image

output:
image

Thanks
Shaik

2

Hi,

Can you try the following sample?

image
image1023×797 18.7 KB

dtResult = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("E212").ToString,r("E214").ToString)).Select(Function(g) g.First()).CopyToDataTable.DefaultView.ToTable(False,{"E212","E214"})

Sample
Sample20240328-2.zip (8.7 KB)

Regards,