cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Subset data after filter

MargauxR
Level III

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