Updating Columns with Calculated Values [message #1221] |
Tue, 09 February 2021 16:41 ![Go to next message Go to next message](/forum/theme/myThemeWithHFCSS/images/down.png) |
ELFritzen
Messages: 47 Registered: November 2019 Location: North Carolina, 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 Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) |
thomas
Messages: 694 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
|
|
|