cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
DVLuna
Level III

Re-ordering the script list saved to a Data Table

I have created a set of scripts for a given data table and I would now like to "re-order" the scripts as they appear in the top left area of the Data Table view.

 

I can't seem to find anything on the forums or in the Help section to address this.

 

Basically the scripts are listed in the order they were created/saved.  Is there a method for sorting/adjusting the list after creation?

 

Thanks in advance for any assistance.

1 ACCEPTED SOLUTION

Accepted Solutions
David_Burnham
Super User (Alumni)

Re: Re-ordering the script list saved to a Data Table

Interactively in JMP you have drag and drop the table scripts to re-order them.  YOu have to do a long-click then drag otherwise the drag movement will simply select multiple scripts.

reorder-jsl.gif

-Dave

View solution in original post

6 REPLIES 6
txnelson
Super User

Re: Re-ordering the script list saved to a Data Table

I am not aware of any simple way to reorder the Table Scripts.  However,  below is a simple script I put together that will alphabetically sort the scripts in a given data table.

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

// Get the list of scripts
names = dt << Get Table Script Names;

// Setup a list to sort alphabetically
namestosort = names;
Sort List Into( namestosort );

// Pull into a list all of the scripts
dt << Select Properties( names );
proplist = dt << Get Selected Properties();

// Pass through the sorted list, deleting each script and
// then resaving it 
For( i = 1, i <= N Items( names ), i++,
	dt << delete Table Property( namestosort[i] );
	Eval( Parse( "dt<<" || Char( proplist[Loc( names, namestosort[i] )] ) ) );
);
Jim
David_Burnham
Super User (Alumni)

Re: Re-ordering the script list saved to a Data Table

Interactively in JMP you have drag and drop the table scripts to re-order them.  YOu have to do a long-click then drag otherwise the drag movement will simply select multiple scripts.

reorder-jsl.gif

-Dave
DVLuna
Level III

Re: Re-ordering the script list saved to a Data Table

David,

 

This is exactly what I was trying to figure out!

 

Perfect.

 

Thank you very much.

 

Dave

wis
wis
Level I

Re: Re-ordering the script list saved to a Data Table

I don't see this working in JMP 13.2.1 (64 bit)

txnelson
Super User

Re: Re-ordering the script list saved to a Data Table

I am running JMP 13.2.1 on 64bit windows and it works fine for me.

Jim
wis
wis
Level I

Re: Re-ordering the script list saved to a Data Table

Well, for whatever reason, it decided to work this morning.