cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
EH1
EH1
Level III

Reorder by Data Type greyed out

Hi,

 

I'm trying to reorder over 2000 columns by data type (character vs numeric), however, the "Reorder by Data Type" option is greyed out in the Column menu (see image).  The columns are not grouped.  I'm using JMP18 on a Mac.

2 ACCEPTED SOLUTIONS

Accepted Solutions
EH1
EH1
Level III

Re: Reorder by Data Type greyed out

Hi Jim - thank you so much!  This worked! Again, thank you!!

View solution in original post

EH1
EH1
Level III

Re: Reorder by Data Type greyed out

Oh, wow!  You're right... the columns I wanted to sort were not grouped, but I did have some other columns grouped.  Removing all groups enabled the menu.  Thank you!

View solution in original post

6 REPLIES 6
txnelson
Super User

Re: Reorder by Data Type greyed out

Not all options are grayed out, if you click on Move selected columns, you will get a window that will give you choices on moving the selected columns.

txnelson_0-1722269542519.png

 

Jim
EH1
EH1
Level III

Re: Reorder by Data Type greyed out

Hi - I'm trying to separate all of the character columns from the numeric columns, but currently they are all mixed together.  If I select each character column individually, I could then use the "Move selected columns" feature. However, since there are over 2000 columns, I was hoping there would be a faster way than selecting columns one by one.

txnelson
Super User

Re: Reorder by Data Type greyed out

Using the Column Manager may be able to do the selection you want, but the following simple script will do it quickly.

 

Names Default To Here( 1 );

dt = Current Data Table();

For( i = 1, i <= N Cols( dt ), i++,
	If( Column( i ) << get data type == "Character",
		Column( i ) << set selected
	)
);

You can also use JSL to do the moving

dt << move selected columns(To First);
Jim
hogi
Level XII

Re: Reorder by Data Type greyed out

Is there any column group in your table?
Seems that the commands get disabled if there is one.

EH1
EH1
Level III

Re: Reorder by Data Type greyed out

Oh, wow!  You're right... the columns I wanted to sort were not grouped, but I did have some other columns grouped.  Removing all groups enabled the menu.  Thank you!

EH1
EH1
Level III

Re: Reorder by Data Type greyed out

Hi Jim - thank you so much!  This worked! Again, thank you!!