Subset data after filter

MargauxR — Sat, 10 Jun 2023 23:20:47 GMT

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

Re: Subset data after filter

txnelson — Tue, 20 Oct 2020 12:56:34 GMT

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

topic Subset data after filter in Discussions

Subset data after filter

Re: Subset data after filter