"Customer3.xlsx [pic] Customer4.xlsx [pic] We can see from the above figures that Cindy and Lily .."

mars RaqForum 25 No.
409 View • 2 Years ago

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

desktop and excel data processing cases(180)

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)