Updating Merged Columns [message #1125] |
Thu, 19 November 2020 16:09 ![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've created a number of merged columns in a DataWarrior file. As an example, the merged column might have data for the same assay from two different vendors. When I add new data to the source columns, I noticed the merged columns are not updated. Is there a way to update merged columns when data is added to the source columns? I know you can re-calculate columns that are calculated values, so this would be similar for updated merged columns.
Thanks,
Ed
Ed Fritzen
|
|
|
|
Re: Updating Merged Columns [message #1127 is a reply to message #1126] |
Thu, 19 November 2020 20:53 ![Go to previous message Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) ![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 |
|
|
Thank you for the prompt reply, nbehrnd,
I understand what you're saying, however, how would the formula change if there were values for both vendor_1 and vendor_2, and you wanted to show both values in the "merged" column. In the attached file, how could I get the vendor_1_2 column (the calculated column) to look like the merged column? Can that be done with a calculated expression?
Thanks for the help.
Ed
Ed Fritzen
|
|
|
Re: Updating Merged Columns [message #1128 is a reply to message #1127] |
Thu, 19 November 2020 21:51 ![Go to previous message Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) ![Go to next message Go to next message](/forum/theme/myThemeWithHFCSS/images/down.png) |
nbehrnd
Messages: 215 Registered: June 2019
|
Senior Member |
|
|
Dear Ed,
based on your reply, I understand that my initial reading of your question does not fit your needs. I wrongly assumed you wish to display in column C at either the result of column A, or of column B. But you want to display both values simultaneously in one column of recalculated values.
This is possible using an expression in the following pattern
str(if(vendor_1!=0,vendor_1,"NaN")) + str("; ") + str(if(vendor_2!=0,vendor_2,"NaN"))
The expression asks both columns independently for a value -- if there is no value, these if clauses will explicitly state the absence by issuing an «NaN» string. These results, regardless if a numeric result, or some text, will be converted into a string. These are separated by a third string comprising a semi-colon and an explicit space (but it could be any other separator character, too [.cvs files]). Eventually, the plus signs are used to concatenate the parts into the string displayed in the table.
Et voilà, in the sixth column (an example .dwar file is attached, too):
![index.php?t=getfile&id=295&private=0](index.php?t=getfile&id=295&private=0)
Norwid
-
Attachment: adjust.dwar
(Size: 2.34KB, Downloaded 342 times)
-
Attachment: adjust-or8.png
(Size: 16.60KB, Downloaded 573 times)
|
|
|
Re: Updating Merged Columns [message #1129 is a reply to message #1128] |
Fri, 20 November 2020 16:00 ![Go to previous message Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) |
ELFritzen
Messages: 47 Registered: November 2019 Location: North Carolina, US
|
Member |
|
|
Thanks, Norwid,
That's exactly what I need. I know very little about writing such expressions. This will be a big help.
Ed
Ed Fritzen
|
|
|