topic What is criteria of column placement when sorting columns by data type? in Discussions

What is criteria of column placement when sorting columns by data type?

RP_64 — Mon, 04 May 2026 13:01:47 GMT

I have table of 172 columns in a specific order that are a mix of character and nominal data types. Using the window on the left side of the table, I sort the columns by type which occurs ok. However, within each type grouping, the columns are no longer in a specific order but seem to have been placed randomly. What is the criteria for the column placements when the sort is done?

Re: What is criteria of column placement when sorting columns by data type?

jthi — Mon, 04 May 2026 17:05:08 GMT

According to

Using JMP > Enter and Edit Your Data > Organize Data in Data Tables > Rearrange Columns in Data Tables

Reorder By Data Type

Arranges the columns from left to right in alphabetic order by data type (expression, row state, character, or numeric).

So I would guess the columns are moved to data type groups (character, expression, numeric, row state) and stay then they stay in original order within those groups.