topic Re: Select a range of rows with variables in Discussions

Select a range of rows with variables

natalie_ — Thu, 11 Feb 2016 22:15:04 GMT

Hi everyone,

Is it possible to select a range of rows with variables?

This is what I have, but it found the maximum over the entire range:

vlower = lowerVoltage << get;

vupper = upperVoltage << get;

row1 = (vlower/10)+1;

row2=(vupper/10)+1;

select_rows = row1::row2(dt2);

select_values = dt2:Idoff(select_rows);

id = maximum(select_values);

Re: Select a range of rows with variables

txnelson — Fri, 12 Feb 2016 04:22:26 GMT

Natalie,

If I understand what you are asking for, I believe the jsl you want would be:

vlower = lowerVoltage << get;

vupper = upperVoltage << get;

row1 = (vlower/10)+1;

row2=(vupper/10)+1;

select_rows = row1:row2;

id = maximum(dt2:Idoff[select_rows]);

dt<<select rows(select_rows);

Re: Select a range of rows with variables

natalie_ — Fri, 12 Feb 2016 14:50:48 GMT

Thank you, so simple! Thank you for helping me with more JSL syntax!