I have a datatable the has duplicate lines. I need to get the duplicate lines for a student and compare the duplicate lines for the best value in certain columns to create one column for each
"StudentID":"432009", has 3 lines. I need to add some logic to compare each column and make one column with the best value (or one that a logic decides)
Not sure if this is something that someone has tried before or something that's kind of built in. I can add some logic in place to find the right value.
**note.. All values are a string. Would have to add something to convert the number strings to an int and compare.
This question has an accepted answers - jump to answer