openmolecules.org

 
Home » DataWarrior » Bug Reports » File>Merge Files could not match column names (When using "Merge Files" to update existing columns from multiple CSV file)
File>Merge Files could not match column names [message #2372] Tue, 14 January 2025 15:25 Go to next message
zhentg is currently offline  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.

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 Go to previous messageGo to next message
nbehrnd is currently offline  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

[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 Go to previous messageGo to next message
zhentg is currently offline  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 27 times)


Datawarrior is a good tool

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

Report message to a moderator

Re: File>Merge Files could not match column names [message #2381 is a reply to message #2378] Wed, 22 January 2025 18:07 Go to previous message
thomas is currently offline  thomas
Messages: 722
Registered: June 2014
Senior Member
Hi zhentg and Norvid,

when a task is performed a second time, DataWarrior tries to reconstruct the task configuration of the previous run, because often tasks are repeated with just slight modifications.

In this case the dialog setup for the second merge didn't find the setting for 'property2' and wrongly set the option to 'trash it'. That should be fixed in the next update...

Thanks for reporting...

Thomas

Report message to a moderator

Previous Topic: Impossible to use due to add
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Feb 05 13:01:51 CET 2025

Total time taken to generate the page: 0.02968 seconds
openmolecules.org