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>;
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.
LabTalk: colstats output to same sheet
Posted - 07/10/2020 : 07:52:04 AM
