topic select where on multiple columns in Discussions

select where on multiple columns

ENTHU — Mon, 11 Nov 2019 03:21:11 GMT

I have a data table with 60 columns and I'm trying to select columns which have "Test" in their name.I then need to select all 1.values that lie in the range 50 & -50 in Test_AB;

2.values that lie in the range 100 & -100 in Test_CD;

3.values that lie in the range 200 & -200 in Test_EF;

and delete other rows.

Is there an easy way to do this in JSL?

Thanks

Re: select where on multiple columns

txnelson — Mon, 11 Nov 2019 05:40:40 GMT

Below is an example of how to do the items you request

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

// Find all columns that have PN in their name, and select the column
For( i = 1, i <= N Cols( dt ), i++,
	If( Contains( Column( dt, i ) << get name, "PN" ),
		Column( dt, i ) << set selected
	)
);

// Select the required rows
dt << select where(
	118 <= :NPN1 <= 122 | 
	360 <= :PNP1 <= 300 | 
	500 <= :PNP2 <= 510
);

// Delete the non selected rows
dt << invert row selection;
dt << delete rows;

These 2 tasks are very elementry items in JSL. With the number of interactions you have had on the Discussion Forum, I would have expected you to have been able to handle your issue without help from the Discussion Group. If you are still having issues with writing your own JSL, then I strongly suggest that you sign up for a training class on JSL, and even more strongly suggest you take the time to read the Scripting Guide.

Re: select where on multiple columns

ENTHU — Mon, 11 Nov 2019 06:09:42 GMT

Thanks for the response.
Well, with my knowledge through all the interactions in this forum I already had written this piece of code before posting.The intent behind asking this question was to see if there is an "easy" way to do this.By that I mean lesser number of lines.Also if there is a way to avoid loops.I have multiple loops in the script and that slows down the execution.

Re: select where on multiple columns

txnelson — Mon, 11 Nov 2019 06:26:25 GMT

If you already had working code it might be very useful to include it in your request. Many times a modification of your working code will the best thing to achieve your results.