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