Data table - combine and keep most recent

Help Community
,
7

so after a bit of research and some chat-gpt trial and error i got this

create an assign activity for a new dt
DT_Result = (From row In DT_Final.AsEnumerable()
Group row By empID = Convert.ToInt32(row(“Employee ID”)) Into grp = Group
Let maxRunID = grp.Max(Function(r) Convert.ToInt32(r(“Run ID”)))
Select grp.Where(Function(r) Convert.ToInt32(r(“Run ID”)) = maxRunID).First()).CopyToDataTable()

that worked

so @Anil_G thanks for the advice about the date \ counter

1 Like