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

Re-ordering the script list saved to a Data Table

DVLuna — Wed, 26 Jul 2017 01:06:48 GMT

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.

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

txnelson — Wed, 26 Jul 2017 02:39:06 GMT

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] )] ) ) );
);

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

David_Burnham — Wed, 26 Jul 2017 08:49:37 GMT

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.

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

DVLuna — Wed, 26 Jul 2017 09:16:27 GMT

David,

This is exactly what I was trying to figure out!

Perfect.

Thank you very much.

Dave

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

wis — Wed, 13 Dec 2017 00:12:33 GMT

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

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

txnelson — Wed, 13 Dec 2017 01:14:01 GMT

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

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

wis — Wed, 13 Dec 2017 16:48:32 GMT

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