Hi, I have a table full of duplicate leads, all with different attributes. E.g. File Number Name Favorite Color City Number of children 123 Peter Pan Red 3 123 Peter Pan Boston 3 What’s the best way to merge this information?I think it’s ok to have some duplicates (like “3 3”), so appending might work for some cells. But I don’t how I can clean up tables in general. Thanks so much Sebastian

Question

How to merge duplicate values in Zapier Tables

Userlevel 1

Hi,

I have a table full of duplicate leads, all with different attributes.

E.g.

File Number	Name	Favorite Color	City	Number of children
123	Peter Pan	Red		3
123	Peter Pan		Boston	3

What’s the best way to merge this information?

I think it’s ok to have some duplicates (like “3 3”), so appending might work for some cells. But I don’t how I can clean up tables in general.

Thanks so much

Sebastian

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Userlevel 7

+14

Hi @ssielmann

Good question.

That depends on your logic to determine duplicates and how you want to merge the data.

Generally, it’s easiest to do this in GSheets with formulas to assist.

Userlevel 1

Thanks so much :)

The logic would be:

If the target cell is empty: Overwrite
If the target cell is not empty AND the value is the same: Don’t overwrite
If the target cell is not empty AND the value is not the same: Don’t overwrite and send new value to a list somewhere → this might be hard?

Delete old record after executing this.

Userlevel 7

+14

@ssielmann

Zapier Tables doesn’t have this type of deduplication functionality yet, so it would be a manual process to merge records or delete records.

Userlevel 1

Hi @ssielmann what’s the action to execute after you’ve merged those records as a follow-up?

Userlevel 1

I’m working on a solution… Anyone interested in?