4.16 Merge and de-duplicate by row - duplicate row headers - delete all duplicate data

 

CustomerTotal.xlsx
imagepng

Customer.xlsx

imagepng

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:

imagepng

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


esProc Desktop and Excel Processing
4.15 Merge and de-duplicate by row - duplicate row headers - keep non-null data
4.17 Merge and de-duplicate by column - duplicate column names - keep data in columns that appear later