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
esProc Desktop and Excel Processing
4.12 Merge by column - one to many - leave subsequent rows empty
4.14 Merge and de-duplicate by row - duplicate row headers - keep the data that firstly appear
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/
