Hello everyone,
I have a problem for a little while on JMP, I use the tabular option to calculate averages (about 900 columns)
All columns start with the same expression "tps #number"
I'm looking for a script that could execute this array option with a variable that would store all these "tps... »
An example of the database and code I'm using:
dt = Current Data Table();<BR />abc_cols = Filter Each( {col_name}, dt << Get Column Names( "String", Continuous ),
Starts With( col_name, "tps" )
);
Local( {obj},
obj = Data Table( "B" ) << Tabulate(
Show Control Panel( 0 ),
Add Table(
Column Table(
Analysis Columns(
Column(abc_cols)
),
Statistics( Mean )
),
Row Table ( Grouping Columns ( :Article))
)
);
obj << Make Into Data Table;
obj << Close Window;
);
