| T O P I C R E V I E W |
| RandomOUser |
Posted - 07/10/2020 : 07:52:04 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2020 (64-bit) SR1 .7.0.188 (Academic)
Operating System: Windows 10
Dear community,
I am looking for a way to tell the X-Function colstats in a LabTalk-Script (.ogs) to write its output into new columns of the same sheet instead of a new sheet.
This does the statistics but creates a new sheet for the output:
colstats 3:12
This does not work (since it appears there is no output / report data object for colstats):
colstats 3:12 rd:=[<input>]<input>!<new>;
Thanks for your help!
|
| 1 L A T E S T R E P L I E S (Newest First) |
| RandomOUser |
Posted - 07/10/2020 : 08:13:29 AM
I just found out how to do this. For future reference / anyone interested in this:
Basically, you can specify the full path for each output argument like so:
colstats 3:12 min:=[<input>]<input>!<new> max:=[<input>]<input>!<new>;
The default output (such as average, n, median etc.) will in this case still be written to a new sheet. So each output attribute has to be manually overwritten. The full command then looks like this:
colstats 3:12 col:=[<input>]<input>!<new> mean:=[<input>]<input>!<new> sd:=[<input>]<input>!<new> n:=[<input>]<input>!<new> median:=[<input>]<input>!<new> min:=[<input>]<input>!<new> max:=[<input>]<input>!<new>;
This seems rather unnecessarily complicated. So in case anybody has a better solution, I'd still be interested. |
|
|
