...
4.15 Merge and de-duplicate by row - duplicate row headers - keep non-null data
Customer3.xlsx
Customer4.xlsx
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:
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) |
