Home » DataWarrior » Functionality » calculated props after file merge/append
calculated props after file merge/append [message #319] Mon, 09 April 2018 16:41 Go to next message
Messages: 1
Registered: April 2018
Junior Member
First post, so let me start of by saying what an awesome piece of software Datawarrior is.

But there is a little hiccup in my workflow that maybe I can get help with here. Or maybe it will turn into an improvement suggestion.

I have a .dwar file with compounds, experimental data, and a bunch of calculated properties (eg cLogP). I get new data in an SD file every week, that I merge into the .dwar file. When the merge is done, the new compounds do not have calculated properties. There is an empty field in the cLogP column for those new compounds.
I cannot find an easy way to populate those empty fields. I end up recalculating the properties, which creates new columns (eg cLogP 2). Was kind of hoping right clicking on the cLogP column header would give me the option to recalculate or something like that.

Am I missing something obvious, or am I using the best workaround already?

kind regards
Re: calculated props after file merge/append [message #320 is a reply to message #319] Mon, 09 April 2018 21:22 Go to previous message
thomas is currently offline  thomas
Messages: 179
Registered: June 2014
Senior Member
Thanks for the praise. Multiple times is was considering to store the calculation history of data columns in order to allow fresh calculation of values for updated or new structures. The problem is, that this may get quite complex with columns recursively depending on other columns alphanumerical content or on chemical structures or on descriptors. A change may trigger cascades changes on other columns. Therefore I finally have chosen not to provide that kind of feature.

However, you should be able to solve the issue in a different way: Just create a macro that deletes all calculated property columns, then merges the new file, and then freshly calculates the property columns. If you export the macro into a dwam file and put it into the 'macro' folder in the DataWarrior installation directory, the macro is always directly accessible from the 'Macro' menu.

Hope this helps,

Previous Topic: FlyingObjects.dwar's picture and description fields
Next Topic: 2D Rubber Band Scaling (RBS)
Goto Forum:

Current Time: Sat Feb 23 16:01:13 CET 2019

Total time taken to generate the page: 0.00356 seconds