cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
tonkatsu2020
Level II

how to script for finding maximum, minimum date value in a row for 100+ columns

i have a table with 500+ rows and 100+ columns. Populated with numeric values (dates). I need to find the maximum and minimum value along each row for earliest and latest date. i guess the script would be similar to 'Maximum (column1........column100)' for each row. But i am not sure how to script the column ranges along each row.  

10 REPLIES 10
txnelson
Super User

Re: how to script for finding maximum, minimum date value in a row for 100+ columns

Might this formula

If( Row() == 1,
	nc = N Cols( Current Data Table() )
);
Mean( As Column( nc - 4 ), As Column( nc - 3 ), 
	As Column( nc - 2 ), As Column( nc - 1 ) );

be something in the direction you are looking for

 

Jim