4.13 Merge and de-duplicate by row - duplicate whole row of data
If the whole row of data is duplicated when merging by row, only one of the same records will be kept during the merge. For example:
Before merging:
and
As can be seen from the above figures that the whole row of data in Cindy and Lily rows are duplicated. The merged result is as follows:
Script:
| A | |
|---|---|
| 1 | =file(“Customer1.xlsx”).xlsimport@t().sort(Name,Times) |
| 2 | =file(“Customer2.xlsx”).xlsimport@t().sort(Name,Times) |
| 3 | =[A1,A2].merge@u(Name,Times) |
| 4 | =file(“CustomerTimes.xlsx”).xlsexport@t(A3) |
A1: The original data need to be sorted because of merge
A3: merge@u means the union, using Name and Times as criteria for judging duplication, therefore, if the whole row is used as the criteria, then all the field names should be added
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1652833363586
https://c.scudata.com/article/1652937604776
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/
