topic Re: Reorder by Data Type greyed out in Discussions

Reorder by Data Type greyed out

EH1 — Mon, 29 Jul 2024 16:06:23 GMT

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.

Re: Reorder by Data Type greyed out

txnelson — Mon, 29 Jul 2024 16:12:28 GMT

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

EH1 — Mon, 29 Jul 2024 16:22:59 GMT

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

txnelson — Mon, 29 Jul 2024 17:01:12 GMT

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

hogi — Mon, 29 Jul 2024 17:26:23 GMT

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

EH1 — Tue, 30 Jul 2024 14:02:20 GMT

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

Re: Reorder by Data Type greyed out

EH1 — Tue, 30 Jul 2024 14:04:41 GMT

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!