282313_en-US

liliconcom

JSL Options for Reordering Columns Numerically

Are there any options for reordering columns in JSL beyond "Reorder by Name, Modeling Type, Data Type"?

I'm looking to reorder some columns with names and numerical indexing. The columns are named in the following manner- "Column Data 1 (1), Column Data 1 (2), ...., Column Data 99 (1), Column Data 99 (2),...".

Using the reorder by name option basically reorders the data (1), (100), (101), (102),.. ordering it by text rather than numerically.

Are there any options JSL introduces that would make sorting this data simpler? I have ~2200 columns to organize.

Using JMP 14.1.0

 

ScriptingRe: JSL Options for Reordering Columns Numerically

Cool! 

Re: JSL Options for Reordering Columns Numerically

names default to here(1);

// Create a new data table with columns that resemble your columns
dt = New Table( "Example" );

// Create a bunch of new columns
For(i=1,i<=100,i++,
 dt << new column( "Column Data " || char(randominteger(1,10)) || "(" ||
  char(randominteger(1,99)) || ")"
 )
);
// Get rid of columns that are duplicates
For(i=100,i>=1,i--,
 if(substr(column(dt,i)<<GET name=""></GET>

 Above is a script that first builds a sample data table, and then reorders the columns numerically