cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
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.