I am currently using AsEnumerable to group by my DataTable. It is working perfectly in Visual Studio. But once i use it in Pega, it has wrong result. It has the same datatable and code in visual studio.

Here is my code:

dtNew = tbl.AsEnumerable().GroupBy(row => row.Field<string>("Distinct")).Select(group => group.FirstOrDefault()).CopyToDataTable();