How to drop duplicates and only retain maximum value

sgschauer — Fri, 29 Sep 2023 00:41:17 GMT

I'm trying to consolidate this data table. I previously used Excel for it but it is >18,000,000 lines of data which is too big for Excel. I have multiple different values for the same subject and I only want to retain the maximum value and delete the rest. The table-join-table method does not have a maximum value only option. How do I go about consolidating this?

Re: How to drop duplicates and only retain maximum value

jthi — Fri, 29 Sep 2023 04:37:42 GMT

Below are few options

Create summary table where you use columns you wish to keep as group columns and then calculate max if the value you want the max from
Sort the data based on the value you want to max value for and use Select Duplicate Rows when you have grouping columns selected and delete the selected rows
Write a formula formula which will add new column to tell if column is max or not
1. :VALUE == Col Max(:VALUE, :GROUP1, :GROUP2) or something similar

topic Re: How to drop duplicates and only retain maximum value in Discussions

How to drop duplicates and only retain maximum value

Re: How to drop duplicates and only retain maximum value