topic Re: Script to Create Subset and Add Columns in Discussions

Script to Create Subset and Add Columns

mjvincent87 — Wed, 04 Dec 2019 17:07:04 GMT

New to scripting here, and trying to automate some of my work tasks.

My goal is to create multiple subsets from a master file and add some columns that will allow me to factorize the data. Right now I am playing around with the data trying to learn. Here's what I have:

//Select data table
dt = Open( "FM_OwnshipState.jmp" );
//Card1
dt << Select Where( :LocalTime >= 6:59:00 & :LocalTime <= 6:59:05 );
dt << Subset( Output Table( "Card1.jmp" ), Selected Rows( 1 ), selected columns( 0 ) );
dt1 = ( "Card1.jmp" );
Current Data Table ( dt1 );
dt1 << New Column ( "Pub", After Last, Character );
dt1 << New Column ( "Beer", After Last, Character );
dt1 << New Column ( "Drink", After Last, Character );

It seems I can create the new subset, but it does not add the new columns to the subset of the data.

Re: Script to Create Subset and Add Columns

Mark_Bailey — Wed, 04 Dec 2019 17:22:05 GMT

You made it too complicated.

//Select data table
dt = Open( "FM_OwnshipState.jmp" );
//Card1
dt << Select Where( :LocalTime >= 6:59:00 & :LocalTime <= 6:59:05 );
dt1 = dt << Subset( Output Table( "Card1.jmp" ), Selected Rows( 1 ), selected columns( 0 ) );
dt1 << New Column ( "Pub", After Last, Character );
dt1 << New Column ( "Beer", After Last, Character );
dt1 << New Column ( "Drink", After Last, Character );

Re: Script to Create Subset and Add Columns

mjvincent87 — Wed, 04 Dec 2019 19:49:56 GMT

Good stuff, thank you!