Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

How do I filter out dup. data from 12,000 records?

JohnnyZ
in Finding & Searching

Featured Replies

I have an Excel file containing approx. 12,000 records that I imported to FMP. How can I filter out duplicate records? For example: The fields are serial number, product name, and sales order#. I want a count of each serial # only once, even though the serial # may exist several times with different sales order #'s. It seems like a simple task, but I'm stumped. TIA for any advice.

Cheers!

Johnny Z

What defines a unique record? Or how would you know that a given record is or is not a duplicate?

Once you know this, then you can setup a script to loop through the records and compare them, deleting the duplicates.

  • Author

All records should be unique once the list is filtered. Duplicte records are defined as those that share serial# and date. If the serial# re-occurs with another date, then that is a unique record. I will experiment with some looping scripts. Thanks for your idea!

  • Author

I tried the self join relationshiip techinque and it worked! Now I need to fully understand why. It's much more efficient than a script. Thanks!

Johnny Z

Create an account or sign in to comment

https://fmforums.com/topic/13453-how-do-i-filter-out-dup-data-from-12000-records/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.