Jul 21, 2021deduplicating for row-style ExcelA file has multiple columns of data. The first row is the column name, and the second row is the data record. Compare the key columns in the file, delete the duplicate rows in the key column or keep only the duplicate rows. The current sales order table order_2018.xlsx for…2 min read2 min read
Jul 21, 2021Simple data deduplicationExample1 There is a sequence of numbers, you need to select the number that is not repeated. Write SPL script:2 min read2 min readSimple data deduplicationExample1There is a sequence of numbers, you need to select the number that is not repeated.Write SPL script:----
Jul 21, 2021Deduplicating without changing original ordersExample The Excel file book1.xlsx has two columns of Car and Color. Part of the data is shown in the figure below:2 min read2 min readDeduplicating without changing original ordersExampleThe Excel file book1.xlsx has two columns of Car and Color. Part of the data is shown in the figure below:----
Jul 21, 2021Filter by repetitionsExample There is an Excel file Book1.xlsx, and part of the data is as follows:1 min read1 min readFilter by repetitionsExampleThere is an Excel file Book1.xlsx, and part of the data is as follows:----
Jul 21, 2021deduplicating with related columnsExample Example1 There is an Excel file Book1.xlsx, and part of the data is as follows:2 min read2 min read
Jul 21, 2021Removal with paired dataExample There is an Excel file Book1.xlsx, and part of the data is as follows:2 min read2 min readRemoval with paired dataExampleThere is an Excel file Book1.xlsx, and part of the data is as follows:----
Jul 21, 2021Counting repetitionsExample There is an Excel file mat.xlsx, part of the data is as follows:1 min read1 min readCounting repetitionsExampleThere is an Excel file mat.xlsx, part of the data is as follows:----
Jul 21, 2021counting repetitions for uncertain columnsExample There is an Excel file mat.xlsx, part of the data is as follows:2 min read2 min readcounting repetitions for uncertain columnsExampleThere is an Excel file mat.xlsx, part of the data is as follows:----
Jul 21, 2021Find duplicates and countingExample There is an Excel file Book1.xlsx, part of the data is as follows:1 min read1 min readFind duplicates and countingExampleThere is an Excel file Book1.xlsx, part of the data is as follows:----
Jul 9, 2021An uncertain number of sets to find intersection, union, and differenceExample There are multiple Excel files Book1.xlsx, Book2.xlsx, Book3.xlsx,…, the naming rule of these files is Book[N].xlsx, N is a number starting from 1, the data in the file is as follows: Book1.xlsx2 min read2 min readAn uncertain number of sets to find intersection, union, and differenceExampleThere are multiple Excel files Book1.xlsx, Book2.xlsx, Book3.xlsx,…, the naming rule of these files is Book[N].xlsx, N is a number starting from 1, the data in the file is as follows:Book1.xlsx----