topic Re: How can select data based on the value of another data table? in Discussions

How can select data based on the value of another data table?

lala — Fri, 09 Jun 2023 23:30:00 GMT

For example, using the "Big class.jMP "data, select the number of rows whose "age" corresponds to the value of another table.

Thanks!

Re: How can select data based on the value of another data table?

txnelson — Tue, 23 Jun 2020 05:16:48 GMT

Here is a simple example to do the selections you want

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

// Create the config table
dtCon = New Table( "Config", New Column( "Col", values( {13, 15} ) ) );

// Select the data based upon the values in the Config table
dt << clear select;
For( i = 1, i <= N Rows( dtCon ), i++,
	dt << select where( :age == dtCon:Col[i], current selection( "extend" ) )
);

Re: How can select data based on the value of another data table?

lala — Tue, 23 Jun 2020 06:34:23 GMT

Thank Jim!

Again, There going to use the loop.

Re: How can select data based on the value of another data table?

lwx228 — Tue, 23 Jun 2020 09:28:22 GMT

d1 = Current Data Table();
d2 = Open( "$SAMPLE_DATA/Big Class.jmp" );
d2 << Update( With( d1 ), Match Columns( :age = :age ), Add Columns from Update table( :col ) );
d2 << Select Where( :col > 0 );
d3 = d2 << Subset( Output Table( "test" ), Selected Rows( 1 ), selected columns( 0 ) );

That's all I can do.