...
4.16 Merge and de-duplicate by row - duplicate row headers - delete all duplicate data
CustomerTotal.xlsx
Customer.xlsx
Since the same key columns will be considered as duplicate data, as a key column, the duplicate records of Name column in Customer.xlsx need to be deleted from CustomerTotal.xlsx, and the result after de-duplication is shown as follows:
Script:
A | |
---|---|
1 | =file(“CustomerTotal.xlsx”).xlsimport@t().sort(Name) |
2 | =file(“Customer.xlsx”).xlsimport@t().sort(Name) |
3 | =[A1,A2].merge@d(Name) |
4 | =file(“CustomerTotalNew.xlsx”).xlsexport@t(A3) |
A1: The original data need to be sorted because of merge
A3: option @d means deleting the data that appear in subsequent table sequence from the first table sequence