topic Re: reading data from peak - y and x data in Discussions

reading data from peak - y and x data

katjes — Mon, 31 Mar 2025 10:26:02 GMT

Hi,

I am having JMP 18 and I am looking for a way to read the max peak - I´d like to have the max y and equivalent x value.

Re: reading data from peak - y and x data

txnelson — Mon, 31 Mar 2025 11:36:48 GMT

Here is a simple script that will write the values to the log

names default to here(1);
dt = current data table();

theRow = (dt << get rows where(col max(:signal)==:signal))[1];
show(:"time, min"n[theRow],:signal[theRow]);

Re: reading data from peak - y and x data

katjes — Fri, 11 Apr 2025 13:53:31 GMT

hi, thanks for the great input.

Is there away that it does the data picking for all IDs?

Re: reading data from peak - y and x data

txnelson — Fri, 11 Apr 2025 14:52:17 GMT

It requires just a simple modification to the JSL I originally provided.

names default to here(1);
dt = current data table();

// Find all of the peaks
theRows = (dt << get rows where(col max(:signal, :ID)==:signal));

// Display results
New window("Peak Maximums",
	table box(
		string col box("ID", :ID[theRows]),
		number col box("time, min",:"time, min"n[theRows]),
		number col box("signal", :signal[theRows])
	)
);

// Select the rows in the data table
dt << clear select;
dt << select rows(theRows);