openmolecules.org

 
Home » DataWarrior » Bug Reports » Updating Columns with Calculated Values
Updating Columns with Calculated Values [message #1221] Tue, 09 February 2021 16:41 Go to next message
ELFritzen is currently offline  ELFritzen
Messages: 39
Registered: November 2019
Location: Connecticut, US
Member
I have a number of columns in a DataWarrior containing up to three variables, combining these variables into one column. The expression I use to calculate these values is:

str(if(vendor_1!=0,vendor_1,"NaN")) + str("; ") + str(if(vendor_2!=0,vendor_2,"NaN"))

When I go to update and recalculate these "combined" columns, the columns only recalculate after I change the "Data Type" in each of the variables to either "number" or "automatic", depending on what I see as a data type. So in other words, if the data type in the variable is set to "number", I change the type to "automatic" and then I can recalculate the combined column. If the data type is "automatic", changing it to "number" then recalculating the column works. It's not that critical, as long as I know how to get the calculated values I need. I just wanted to pass this along to see if anyone else has this issue, or if it can be fixed.

Thanks,
Ed


Ed Fritzen

[Updated on: Thu, 11 February 2021 10:57] by Moderator

Report message to a moderator

Re: Updating Columns with Calculated Values [message #1223 is a reply to message #1221] Thu, 11 February 2021 11:22 Go to previous message
thomas is currently offline  thomas
Messages: 523
Registered: June 2014
Senior Member
Hi Ed,

I tried with version 521 and with the current dev version using the following data, but couldn't reproduce the issue.
When changing an entry in one of the vendor columns, I could always recalculate. When I used a 2D-view with the
calculated value on an axis, this also reflected the change. Does the dialog open in your case?

Thomas

vendor_1 vendor_2 Calculated Column
1 0 1; NaN
2 1 2; 1
0 2 NaN; 2
1 3 1; 3
2 4 2; 4
Previous Topic: Converting COD2020 to SDF
Next Topic: calculated values
Goto Forum:
  


Current Time: Sun Aug 07 18:59:38 CEST 2022

Total time taken to generate the page: 0.01654 seconds