1. In the table, there is a large amount of duplicate data in the column store_name, such as: chill26, ftolrxs34. as shown in Figure 1
2. Now I want to count how many non-repeatable store_name are in total. Then you need to remove the duplicate data first to ensure the uniqueness of each row. Reference:Use duplicates quickly to remove heavy weights
3. Select the table, click the drop-down menu of “Duplicate” under the “Data” tab, and click Delete Duplicates. as shown in Figure 2
4. In the Delete Duplicate Warning pop-up window, prompt: The WPS table finds the data next to the selected area. You cannot delete this data since you did not select this data. Select the area The currently selected area (C), click Delete Duplicate (R). as shown in Figure 3
5. In the delete duplicates pop-up window, prompt: Please select one or more columns containing duplicates. Find 333 duplicates; after deletion, 41 unique items will be retained, and click Delete Duplicates (R). as shown in Figure 4
6. In the table, the duplicates have been deleted in the column store_name, and now each row is unique, in line with expectations. as shown in Figure 5
Leave a Reply