777211_en-US

liliconcom

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.

Basic Data Analysis and ModelingConsumer and Market ResearchData AccessData Exploration and VisualizationmacOSRe: 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.

 

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.

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

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.

Re: Reorder by Data Type greyed out

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

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!