Hi Folks, how is going?
I have a Datatable:
Input
[OE-FCO,“5 678,2”,“5 679,7”,“5 679,8”,4633,“5 447,7”,4428,“5 361,2”,4347
OE-FCB,“8 407,8”,“8 409,2”,“8 409,2”,6825,“6 168,0”,5197,“6 218,3”,5249
OE-FZC,“7 189,0”,“7 189,9”,“7 189,9”,5804,“7 189,9”,5804,“7 189,9”,5804
OE-FFB,“9 012,1”,“9 013,1”,“9 013,1”,7224,“6 506,7”,5208,“6 429,1”,5245
OE-FZB,“7 465,0”,“7 466,1”,“7 466,1”,6078,“5 301,7”,4553,“6 486,6”,5203
OE-FZC,“7 189,9”,“7 192,0”,“7 192,0”,5805,“7 192,0”,5805,“7 192,0”,5805]
I want to have a DataTable Output which contains the non duplicate rows of Input, based on the first column, but to keep the last occurrence of the row.
Can you advise?
I tried to use:
Output = Input.AsEnumerable.Reverse.CopyToDataTable
to reverse the datatable first, but the first row stays still on top.
Thank You Guys
Cheers