openmolecules.org Forum: Bug Reports » File>Merge Files could not match column names

Home » DataWarrior » Bug Reports » File>Merge Files could not match column names (When using "Merge Files" to update existing columns from multiple CSV file)

Show: Today's Messages :: Polls :: Message Navigator

File>Merge Files could not match column names [message #2372]

Tue, 14 January 2025 15:25

zhentg
Messages: 27
Registered: March 2020

Junior Member

Hi Thomas,

When using "Merge Files" to update existing columns from multiple CSV file
- the column names in the first CSV (Book2.csv) can be automatically matched to exisiting column names
- the column names in the second (Book3.csv) and more CSV files can not be automatically matched to exisiting column names.

This issue is annoying when there are a lot of columns in the master DW file. Could you help to solve it?

This issue is found in DW5.5 and 6.04.01 Windows versions.
Attached are a master DW file and two CSV files.

Attachment: Data_From_Clipboard.dwar
(Size: 2.50KB, Downloaded 13 times)
Attachment: Book2.csv
(Size: 0.04KB, Downloaded 11 times)
Attachment: Book3.csv
(Size: 0.04KB, Downloaded 12 times)

Datawarrior is a good tool

Report message to a moderator

Re: File>Merge Files could not match column names [message #2373 is a reply to message #2372]

Tue, 14 January 2025 22:14

nbehrnd
Messages: 229
Registered: June 2019

Senior Member

Hi zhentg,

can you check (and if the problem still occurs, report) which level of "merge option" did you select (cf. screen photo attached)? Both Book2.csv and Book3.csv merged fluently into Data_From_Clipboard.dwar.

Regards,

Norwid

Attachment: merge_options.png
(Size: 17.75KB, Downloaded 14 times)

[Updated on: Tue, 14 January 2025 22:14]

Report message to a moderator

Re: File>Merge Files could not match column names [message #2378 is a reply to message #2373]

Mon, 20 January 2025 11:14

zhentg
Messages: 27
Registered: March 2020

Junior Member

Hi Norwid, here is my screenshot, the issue is still there.
I merged Book2.csv at step 1, then I try to merge Book3.csv, and the "Merge File" panel can not recognize "property2" automatically.

Attachment: Picture1.png
(Size: 952.84KB, Downloaded 5 times)

Datawarrior is a good tool

[Updated on: Mon, 20 January 2025 11:16]

Report message to a moderator

Previous Topic:

Dock structures into protein cavity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jan 21 15:06:27 CET 2025

Total time taken to generate the page: 0.02584 seconds