A 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 2018, some of the data are as follows:


Example1

There is a sequence of numbers, you need to select the number that is not repeated.

Write SPL script:


Example

The Excel file book1.xlsx has two columns of Car and Color. Part of the data is shown in the figure below:


Example

There is an Excel file Book1.xlsx, and part of the data is as follows:


Example

Example1

There is an Excel file Book1.xlsx, and part of the data is as follows:


Example

There is an Excel file Book1.xlsx, and part of the data is as follows:


Example

There is an Excel file mat.xlsx, part of the data is as follows:


Example

There is an Excel file mat.xlsx, part of the data is as follows:


Example

There is an Excel file Book1.xlsx, part of the data is as follows:


Example

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.xlsx

chuxin huo

hello:)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store