cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

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

Subset data after filter

hello Everybody !

I have a problem in my script.

I have a big data table and i would like to subset some lines.

I did a data filter and then subset or show subset, but i don't have "time" to select the filter in the window....

how can i say in the script i have select first my filter and then subset the data table

i tried with a wait but it's not the best way

this is my script and i link my data base

thank you for your help !!

 

Margaux R
1 REPLY 1
txnelson
Super User

Re: Subset data after filter

Here is one way of handling the issue.  By wrapping the Data Filter in a Modal window you can stop the processing until the selections are made.

dt = Current Data Table();
nw = New Window( "zippy",
	<<modal,
	obj = dt << Data Filter(
		Location( {325, 213} ),
		Conditional,
		Add Filter(
			columns( :Propriétés, :Date d'analyse ),
			Display(
				:Date d'analyse,
				Size( 223, 63 ),
				List Display
			)
		)
	)
);
If( nw["button"] == 1,
	dtNew = dt << subset(
		selected columns( 0 ),
		selected rows( 1 )
	);
	dt << clear row states;
);

Jim

Recommended Articles