I have a table which contains products, owner and prices and products are not distinct as an example generate a dummy table using:
Upload = table();Upload.Name = ['A'; 'B'; 'C'; 'C'];Upload.Owner = ['D'; 'E'; 'F'; 'G'];Upload.Price = [10; 20; 40; 30];
From the above table how can I get distinct rows based on row number. I want to get the 2nd row in case where there is a duplication the output would be:
Upload = table();Upload.Name = ['A'; 'B'; 'C'];Upload.Owner = ['D'; 'E'; 'G'];Upload.Price = [10; 20; 30];
How can I achieve distinct row based on price value, where the choosen row would be the one where price is highest. The output would be:
Upload = table();Upload.Name = ['A'; 'B'; 'C'];Upload.Owner = ['D'; 'E'; 'F'];Upload.Price = [10; 20; 40];
Best Answer