How to hide and exclude rows based on multiple criteria?

Heidi

Hi,

I'm new to JSL.  Here is my table. Under same ID and temp I want to exclude rows with higher current. I've been struggled with this and thanks in advance if anyone can help me out...

	ID	Temp	Current	Value
	C	25	35	1.14
	C	55	48	1.43
	C	70	60	1.64
	C	80	65	1.59
	D	25	35	1.18
	D	55	48	1.47
	D	70	60	1.68
	D	80	65	1.64
	E	25	35	1.2
	E	55	48	1.48
	E	70	60	1.65
	E	80	65	1.59
	F	25	35	1.13
	F	55	48	1.36
	F	70	60	1.53
Hide and Exclude	F	70	65	1.66
	F	80	65	1.41
Hide and Exclude	F	80	70	1.51

Jeff_Perkinson

You can do this all interactively in the data table.

 

Start by sorting the data table by ID, Temp and Current.

 

 

Then, you can create a new column that looks for repeated ID, Temp combinations and sets an indicator.

 

Now you can right click on one of the 1's in the new column and choose Select Matching Values. That will select all the rows that have a 1 in that column. Now you can Hide and Exclude the rows.