topic Re: How do I select specific rows? in Discussions

How do I select specific rows?

micromoccia — Sat, 10 Jun 2023 23:30:56 GMT

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!!

Re: How do I select specific rows?

Jeff_Perkinson — Fri, 28 May 2021 16:01:24 GMT

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?

Re: How do I select specific rows?

micromoccia — Fri, 28 May 2021 18:20:45 GMT

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.

Re: How do I select specific rows?

Jeff_Perkinson — Fri, 28 May 2021 18:28:23 GMT

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?

Re: How do I select specific rows?

micromoccia — Fri, 28 May 2021 19:33:33 GMT

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.

Re: How do I select specific rows?

Jeff_Perkinson — Fri, 28 May 2021 19:39:20 GMT

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
);

Re: How do I select specific rows?

micromoccia — Fri, 28 May 2021 20:14:30 GMT

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

Re: How do I select specific rows?

micromoccia — Tue, 01 Jun 2021 14:37:09 GMT

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

Re: How do I select specific rows?

Jeff_Perkinson — Tue, 01 Jun 2021 14:48:39 GMT

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 );