Max value of each row across multiple columns and the corresponding name of the source column

ILoveJMP

Hi, is there an easy way to find the max value of each row and the column name (or parameter) corresponding to the max value? Below is a simple example to illustrate the request:

 

T1	T2	T3	T4	T5	T6	T7	T8	T9	T10	Max_Value	Col_Name (Parameter)
87.2	83.6	81.4	83	83	83	83	82.3	83.3	84.6	87.2	T1
85.9	84	82	84	83.3	83.3	84	83	86.5	87.2	87.2	T10
84.9	82.7	86	83	82.3	82.3	83	82	83.6	85.2	86	T3
85.6	84.6	82.7	84.6	84.3	84.3	84.3	83.6	84.9	86.2	86.2	T10
85.2	83.6	82	83.3	83	83	83.3	82.3	84.3	85.6	85.6	T10
86.8	84.3	82.7	84.3	83.6	83.6	84.3	83.3	85.9	86.2	86.8	T1
86.2	84	82.3	84	87	83.3	83.6	83	84.9	85.9	87	T5
88.1	84.6	82.3	84.3	83.6	84	84.3	83.3	85.9	86.2	88.1	T1
85.6	83.3	81.7	83.3	83	83	83.6	82.7	84	85.9	85.9	T10
37.4	36.1	36.4	36.4	36.1	36.1	36.4	35.4	36.7	37.4	37.4	T1
36.7	34.5	34.8	34.5	33.8	34.1	34.5	33.5	36.1	36.1	36.7	T1
34.8	32.9	33.2	32.9	32.2	32.5	36	31.9	33.8	35.1	36	T7
38	36.4	36.4	36.4	36.4	36.1	36.7	39	38	38.3	39	T8
38	35.1	35.1	40	34.1	34.5	34.8	33.8	36.4	37	40	T4

 

Thanks!

Craige_Hales

The data table subscripting is new in JMP 13.

You can try something like this idea to build an expression that will create a row vector matrix from the current row when evaluated. 

dt = New Table( "Untitled",
    Add Rows( 3 ),
    New Column( "first", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [1, 5, 9] ) ),
    New Column( "second", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [2, 6, 10] ) ),
    New Column( "skip", character, setvalues( {"a", "b", "c"} ) ),
    New Column( "third", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [3, 7, 11] ) ),
    New Column( "fourth", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [4, 8, 12] ) )
);

names = dt << getcolumnnames( "numeric" ); // returns a list of all numeric column names
Show( names ); // {first, second, third, fourth}
Substitute Into( names, Expr( {} ), Expr( Concat() ) );
Show( Name Expr( names ) ); // first || second || third || fourth

Row() = 2; // names will pull data from the current row
rowvec = (Eval( names )); // [5 6 7 8]

Given a list of row names, the Substitute Into() function replaces the curly bracket list operator with the concat function. Concat function is the same as the || concatenation operator and can take a lot of arguments. The concatenation evaluates each column reference in the list for the current row. The individual scalar values are concatenated into the row matrix.