no worries
–hope we have the datatable variable ready on hand
if so yourdatatablevariable = yourdatatablevariable.Asenumerable().Gropyby(Function(a) a.Field(of string)(“Cardnumber”)).Select(Function(b) b.First()).CopyToDatatable()
1) Use read range activity and store result in **dt**
2) Use assign activity for query **dt** = Dt.DefaultView.Totable(True, "Cardnumber ","Document number")
3) **dt** will have result of
yah it should be like this in assign activity
listOfPostings = listOfPostings.Asenumerable().Gropyby(Function(a) a.Field(Of String)(“Cardnumber”)).Select(Function(b) b.First()).CopyToDatatable()