How To Remove Dupes From One Google Sheet

How To
,
1

Hi Everyone!

I know how to create a scenario to find duplicates in two separate Google sheets.

I just am not sure how to find duplicates in one Google sheet.

Here is what I came up with, but it’s not passing past the filter, since the Google sheet it needs to search, is empty.

Can someone provide a scenario outline since I am a visual learner?

Thank you!

IMG_1582
IMG_15821941×832 108 KB

IMG_1583
IMG_15831172×2005 320 KB

IMG_1584
IMG_15841425×1957 246 KB

IMG_1585
IMG_15851166×1944 295 KB

IMG_1586
IMG_15861119×1220 87.7 KB

IMG_1587
IMG_15871393×1970 211 KB

2

Hi @Mary_Kirkou
To remove duplicates in a sheet you can first search to get all the rows
Sample sheet:
image
(upload://tNor2C7KqYgfzebFxCeEDYt2f0f.png)
Here we are considering ID as unique data.
You can now use an array aggregator and group by ID. The output from the array aggregator will look like this:

image
image686×897 66.9 KB

Output of array aggregator:
image
image856×893 55.9 KB

If the array length is greater than 1, it indicates that the ID is duplicated. You can then retrieve the duplicated row numbers and proceed to delete them.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

3

Thank you so much for your help!!

I got it to work.

I am noticing that the rows are grouped together, so I wondered if you have any suggestions on how to find the group that has the duplicates? I don’t want to delete the wrong rows.

I have about 500 records.

Any suggestions?

Thank you!

1 Like
4

Hi @MaryK
Could you clarify what you mean by groups with an example.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

5

Hi, when I created the scenario, I used the “Group” in the Array Iterator.

So, I think that may have produced duplicates, randomly, throughout the whole spreadsheet.

It’s difficult to find except by checking them, one at a time, which unique ID’s (SCOTT #) are the duplicates. It becomes very time consuming, since there are 500 rows.

I also tried removing the “Group” option in the module, but it was so slow. I had to stop it.

Here are some examples.

IMG_1638
IMG_16382048×589 229 KB

IMG_1639
IMG_16392048×424 168 KB

IMG_1641
IMG_16412048×724 283 KB

IMG_1643
IMG_16432048×994 428 KB

1 Like
6

Hi, @Msquare_Automation!

I figured it out. Someone helped me.

TY

2 Likes
7

Hi @Mary_Kirkou
Glad to know that your issue is resolved now. If you need further assistance please feel free to reach out.

Best regards,

Msquare Automation
platinum Partner of Make
@Msquare_Automation