Forum Discussion

TimD's avatar
TimD
Qrew Trainee
10 months ago

Efficient ways to find duplicates from a specific field.

Hello,

Usually, i use a formula query to identify duplicates for a specific field but on this one table, it has over 500k records and the query cannot handle it. Have you guys find another solution in finding duplicates? I was hoping to mark the individual records (formula-checkbox) to see which records have the same info for the same field.

thanks!



------------------------------
Tim D
------------------------------

1 Reply

  • You can do it the "old school" way, which is to have a parent table of unique values, and a summary field to count the number of children and then look up that summary value back down to the children and you will know on each child a count of how many identical twins there are among those children.  

    The post here describes how you would initialize that parent table and how you would keep it updated using a pipeline.  

    https://community.quickbase.com/discussion/download-to-mulitiple-csvs-based-on-field-value



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------