"Before merging: CustomerFruits.xlsx [pic] and CustomerMeats.xlsx [pic] It can be seen from the f .."

mars RaqForum 25 No.
182 View • 1 Years ago

4.17 Merge and de-duplicate by column - duplicate column names - keep data in columns that appear later

desktop and excel data processing cases(180)

Before merging:

CustomerFruits.xlsx
imagepng

and

CustomerMeats.xlsx
imagepng

It can be seen from the figures that the Bread columns are duplicated, and we want to keep the Bread field of the second file and delete the Bread field in the first file after merging. The result is as follows:
imagepng

Script:

	A
1	=file(“CustomerFruits.xlsx”).xlsimport@t()
2	=file(“CustomerMeats.xlsx”).xlsimport@t()
3	=A1.new(Name,Apple,Strawberry,Peach,A2(#).Mutton,A2(#).Pork,A2(#).Bread,A2(#).Duck)
4	=file(“CustomerFoods.xlsx”).xlsexport@t(A3)