Copy 100+ column headers with formulas from a JMP file for JSL scripting

Question

Hello,

For volume data analysis, I was importing excel or CSV large raw data files to JMP and afterward, I was doing copy/paste of 100+ column headers with formulas from one of my prior files to each JMP file manually. I found this method very time consuming and I want to migrate to JSL scripring.

Is there any simple way that I save these 100+ column headers with their formulas from one of my files in a single file (e.g. excel, txt or config) and afterward, for each data analysis, I simply use a JSL script to create these new columns with formuals automatically?

ms · Answer

I think this approach would work in JMP 12.

JSL example of tranfering all formula columns from an old/template table to a new table without the formula columns:

Names Default To Here(1);

// Old table with all desired formula columns
dt = Open("$SAMPLE_DATA/Diabetes.jmp");

// New table without the formula columns
dt_new = dt << subset(Columns({1, 4 :: N Col(dt)}));

//Get scripts for all formulas columns in old table
formula_columns = {};
For(i = 1, i <= N Col(dt), i++,
    If(!Is Empty(Column(dt, i) << get property(Formula)),
        Insert Into(formula_columns, Column(dt, i))
    )
);

//Add formula columns to new table
Current Data Table(dt_new);
Eval List(formula_columns << get script);

jules · Answer

Hi @xenon2090,

I wrote an Add-In that might be useful for you in this situation, Copy Script for Selected Columns. Once installed you can select your formula columns, run the Add-In from the Add-Ins menu, and you will have the script to recreate those exact columns as jsl in your clipboard. Paste that script to a new window, and run anytime you want to add those columns to the current table.

Julian

martindemel · Answer

Though it's not a script, you may want to use this approach as it actually will have just two to four steps, depending on how you count :)

Assumption: You have a JMP Table with those 100+ Columns and Formulas but no data (reference table)

1. Import your data as usual and open the reference table

2. Copying the column names

a) In the column overview on the left, mark all columns, copy (ctrl+c)

b) In the new table mark all columns in the column overview, paste (ctrl+v)

3. Copying the formulas

a) mark all columns in the reference table, right click in the selected area of the table and select "Copy Multiple Column Properties"

b) mark all columns in the new table, right click in the selected area of the table and select "Paste Multiple Column Properties"

This should do what you need.

Note: In JMP 12 ther eis no script for copy multiple column properties, in later versions (at least JMP 14 there is):

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Tiretread.jmp" );
dt << Select Columns( :MODULUS, :ELONG );
dt << Copy Multi Columns Properties;