4.15 Merge and de-duplicate by row - duplicate row headers - keep non-null data

 

Customer3.xlsx

imagepng

Customer4.xlsx

imagepng

We can see from the above figures that Cindy and Lily rows are duplicated, and the row with null Quantity value will be removed during the merge. The result is as follows:

imagepng

Script:

A
1 =file(“Customer3.xlsx”).xlsimport@t().select(Quantity!=null)
2 =file(“Customer4.xlsx”).xlsimport@t().select(Quantity!=null)
3 =A1|A2
4 =file(“CustomerQuantity.xlsx”).xlsexport@t(A3)