Working on multiple data files and creating a summary table that contains the mean, std, etc.Hi,
Lets say we have multiple big class data files, with different height, weight column, etc and I want to create a summary table that contains the mean, standard deviation, cpk, Spec limits, etc.
I want to have a summary data table that lists the mean for example, for the first big class file, do the same thing for the next big class file. Is there are a method that I can use to perform such a task?
Automation and ScriptingRe: Working on multiple data files and creating a summary table that contains the mean, std, etc.The other note I have is that I'm trying to add columns in the table that represent a certain formula of my choosing. Table summary only allows certain options.
I know I can add a formula column to the data table itself, but I'm not sure how to migrate that column to the summary table without choosing a stat option, such as the mean of that table.
Any suggestion is appreciated. Thanks again!
Re: Working on multiple data files and creating a summary table that contains the mean, std, etc.What I would do is to use
Tables=>Concatenate
to put all of the tables into one table. Make sure you select the "Create source column". This will give you a new column in the final data table, which distinguishes between the tables.
Next, use
Tables=>Summary
to create a summary data table.
Use the new "Source" column as a Group variable, which aggregates the statistics into results separately for each of the original input data tables.
Re: Working on multiple data files and creating a summary table that contains the mean, std, etc.Thanks @txnelson for the suggestion. I forgot to mention that I'm trying to write a JSL code to do the task. I found some posts on the community but all mentioning how to perform the task for each table separately. Do you have any guidance in writing the JSL code? thanks!
