cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
tonkatsu2020
Level II

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

Created: Oct 13, 2020 01:41 PM  |  Last Modified: Jun 10, 2023 4:20 PM (4213 views)

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.  

0 Kudos
10 REPLIES 10
txnelson
Super User txnelson
Super User

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

Oct 16, 2020 04:29 PM (533 views)  |  Posted in reply to message from tonkatsu2020 10-16-2020

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