I’m so confused using the Dedupe block. It doesn’t MERGE anything. It just keeps the primary record.
Let’s say I have a table with Name, Email, Phone, Address, and Transactions.
I select find dups records as Name and Email,
2 Records appear.
- has the phone and transactions.
- has the address
How do I merge the address into record 1
or the phone and transactions into record 2.
So I only have one records the with Name, Email, Phone, Address, and Transactions.
What am I overlooking?