Reorder by Data Type greyed out

[#1]

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]

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.

[#3]

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.

[#4]

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

[#5]

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

[#6 · Accepted solution]

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!

[#7 · Accepted solution]

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