Is there any way to speed up the deduping process? My goal is to see “customers” and their “purchases” since my last audit.

Here’s my scenario:


I have a table of “customers” that are linked to their “purchases” in another table


At the end of every month, I receive an automated report of 6k+ users or “customers” that are “active.”


I need to show only those customers and their purchases.

I’ve tried to use the dedupe block but it seems time-consuming to merge over 6,000 records. Any help or guidance would be greatly appreciated.

Kim