Q: Remove Duplicates
Hi, I used another tool to create SKU numbers for my products. There are a total of 1000 random 10-digit numbers. I highlighted the column with the SKUs and ran the Remove Duplicates tool. The tool did not return any information after running. I still had the same number of rows.
So, I wanted to know how the tool will behave when it finds a duplicate. So, I duplicated one of the SKU numbers, selected the column, and ran the tool. Again, the same result, no output from the tool. I checked, and all of the rows were still in the spreadsheet and the duplicate SKU numbers are still in the spreadsheet as well.
Also, your documentation doesn't explain how to use the tool; it only has a description of what it does.
Wei_Sheng
Apr 10, 2025A: Hi, thanks for your question. Are you using the Utilities tab? If so, this feature has been replace by the remove duplicate action in our automation feature. Here is how you can do it
1. Go to the automation tab and create a new automation
2. Choose the "When sheet is edited" trigger, choose the sheet you want to remove duplicate from
3. In action, Choose the "Remove duplicate" action. Then you can choose to analyze all columns or just one column. Based on your description, you should choose the column where you store the SKU number.
When the automation runs, the app will scan all SKU numbers and if it finds duplicate, the whole row will be removed, and only one will be reserved.
Once the automation is created, make any edits in the target sheet to trigger the automation.
Let me know if this helps! Wei