topic Re: Working on multiple data files and creating a summary table that contains the mean, std, etc. in Discussions

Working on multiple data files and creating a summary table that contains the mean, std, etc.

RA899 — Wed, 21 Feb 2024 01:44:50 GMT

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?

Re: Working on multiple data files and creating a summary table that contains the mean, std, etc.

txnelson — Wed, 21 Feb 2024 02:11:55 GMT

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.

RA899 — Wed, 21 Feb 2024 17:33:53 GMT

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!

Re: Working on multiple data files and creating a summary table that contains the mean, std, etc.

RA899 — Wed, 21 Feb 2024 18:07:40 GMT

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!