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
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
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
