cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
micromoccia
Level I

How do I select specific rows?

I am getting more than the selected data from this line:

get_generic(RawDataTable,"nS","Voltage","tHIGH",,400) ;

 

I am also getting all of this data:

 

get_generic(RawDataTable,"nS","Voltage","tHIGH_hs",,60) ;

 

My problem is that tHIGH is pulling every row with tHIGH, including the tHIGH_hs.

I need to know if I can reject the tHIGH_hs in the first line of code?

 

They are different speeds of operation for the test, and I need to produce separate charts for performance. 

When I pull the tHIGH_hs data it filters only high speed. I just need to make a chart for low speed without including the high spped.

 

Thanks!!

8 REPLIES 8
Jeff_Perkinson
Community Manager Community Manager

Re: How do I select specific rows?

It looks like you might be using a custom function here. There is no built-in JSL function get_generic(), so we're not going to be able to help with why it's not doing what you expect.

 

Was the script written by you or are you using a script that someone else wrote?

-Jeff
micromoccia
Level I

Re: How do I select specific rows?

I inherited the script at a new job. The sctirpt pulls any data that has tHIGH in the name. which is unfortunate when I don't want the other tHIGH_hs data. 

Jeff_Perkinson
Community Manager Community Manager

Re: How do I select specific rows?

In that case we'll need to know more about the function definition for get_generic() to see how it's using the arguments internally.

 

Are you familiar with JSL? Or is this your first time looking at it?

 

-Jeff
micromoccia
Level I

Re: How do I select specific rows?

I am becoming familiar. lol

Here is the block of code. It is used to create a pdf that charts the data in time vs voltage. tHIGH is normal operating speed and tHIGH_hs is the high speed operating data. I can isolate the high speed data by changing the code to "tHIGH_hs", and did in another section of the script.

I'm trying to get just the normal operating speed data for this section.

// set up for AC report
win1 = New Window( "Char Report_NS" );
// real spec is 1000KHz
// data table, scale of desired units, by, name, lsl, usl
get_generic( RawDataTable, "V", "Frequency", "fSCL", , 1.7 );
// tHigh = 260nS, tLow = 500nS
// rewrite -- maybe a generic for each??
//get_thighlow(RawDataTable,"nS","tHIGH",260,"tLOW",500) ; // data table, scale of desired units,
// name1, USL1, name2, USL2
get_generic( RawDataTable, "nS", "Voltage", "tHIGH", , 400 );
get_generic( RawDataTable, "nS", "Voltage", "tLOW", , 400 );

I left in all of the previously commented out code.

Jeff_Perkinson
Community Manager Community Manager

Re: How do I select specific rows?

Unfortunately, that still doesn't help understand what the custom function get_generic() is doing and therefore why it's behaving the way it is.

 

Can you look above in the script and see a function() definition for get_generic?

 

It'll look something like:

 

get_generic = function(
	//jsl statements
);
-Jeff
micromoccia
Level I

Re: How do I select specific rows?

Thanks for the input, I'll see if I can find it. This script is 2800 plus lines of code. :(

 

micromoccia
Level I

Re: How do I select specific rows?

THANK YOU!!! I found the function by CRTL-F and here it is:

get_generic = function ( {dt, du, byName, name1, lsl=., usl=.,exact=0 }

I changed the zero to a 1 and I have it filtering what I need. 

 

Thank you for you help,

 

Al Moccia

Jeff_Perkinson
Community Manager Community Manager

Re: How do I select specific rows?

I'm glad you found it. 

 

You don't have to change the function definition. The items in the {} are the arguments for the function and their default values, if unspecified.

 

So, if changing exact=0 to exact=1 worked for you, you could change it back (so other calls to the function continue to work as they have), and then when you call get_generic() just make sure you specify 1 as the last argument:

get_generic( RawDataTable, "nS", "Voltage", "tHIGH", , 400, 1 ); 

 

-Jeff

Recommended Articles