Choose Language Hide Translation Bar
Highlighted
zjuv007
Level III

Creating two new tables based on filtering one column

I have two types (RFR, OUT) in one column, and would like to generate two tables from this labeled "RFR.jmp" and "OUT.jmp", but can't seem to simply figure out how to do this best:

 

obj = dt1 << Data Filter( Add Filter( columns( :Code Type ), where( :Code Type == {"RFR"} ) ) );
	df = dt1 << subset( selected rows( 1 ), selected columns( 0 ) );
	df << Save( "RFR_2014.jmp" );
	df << clear select
	Wait(0.1);
	
	obj = dt1 << Data Filter( Add Filter( columns( :Code Type ), where( :Code Type == {"OUT"} ) ) );
	df = dt1 << subset( selected rows( 1 ), selected columns( 0 ) );
	df << Save( "OUT_2014.jmp" );
	df << clear select

The selection from the previous RFR doesn't appear to clear at all, and therefore it just joins multiple of the RFR column into one data table. I'm guessing this has to do with setting of the current data table... but how do I get control of this?

Any thoughts?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: Creating two new tables based on filtering one column

I think the code below is simpler, when you get rid of the Data Filter.  Also, the Wait(0) will allow the subsets and the selections to be made, prior to executing the next statements.

dt1 << select where(:Code Type == "RFR" );
wait(0);
df = dt1 << subset( selected rows( 1 ), selected columns( 0 ) );
df << Save( "RFR_2014.jmp" );
wait(0);
dt1 << select where(:Code Type == "OUT");
wait(0);
df = dt1 << subset( selected rows( 1 ), selected columns( 0 ) );
df << Save( "OUT_2014.jmp" );
Jim

View solution in original post

1 REPLY 1
Highlighted
txnelson
Super User

Re: Creating two new tables based on filtering one column

I think the code below is simpler, when you get rid of the Data Filter.  Also, the Wait(0) will allow the subsets and the selections to be made, prior to executing the next statements.

dt1 << select where(:Code Type == "RFR" );
wait(0);
df = dt1 << subset( selected rows( 1 ), selected columns( 0 ) );
df << Save( "RFR_2014.jmp" );
wait(0);
dt1 << select where(:Code Type == "OUT");
wait(0);
df = dt1 << subset( selected rows( 1 ), selected columns( 0 ) );
df << Save( "OUT_2014.jmp" );
Jim

View solution in original post

Article Labels

    There are no labels assigned to this post.