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:

imagepng

and

imagepng

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:

imagepng

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