cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-462537%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EJMP%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%A7%E6%8C%87%E5%AE%9A%E3%81%95%E3%82%8C%E3%81%9F%E5%88%97%E3%82%A4%E3%83%B3%E3%83%87%E3%83%83%E3%82%AF%E3%82%B9%E3%82%92%E6%8C%81%E3%81%A4%E5%88%97%E3%82%92%E6%8C%BF%E5%85%A5%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-462537%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E6%9B%B8%E3%81%84%E3%81%A6%E3%81%84%E3%82%8B%E3%81%A8%E3%81%8D%E3%81%AB%E5%95%8F%E9%A1%8C%E3%81%8C%E7%99%BA%E7%94%9F%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%E6%95%B0%E5%BC%8F%20Y%2FX%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%82%92%E8%BF%BD%E5%8A%A0%E3%81%97%E3%81%9F%E3%81%84%E3%81%AE%E3%81%A7%E3%81%99%E3%81%8C%E3%80%81%E8%A4%87%E6%95%B0%E3%81%AE%E5%88%97%E3%81%8C%E3%81%82%E3%82%8A%E3%80%81%E6%8C%87%E5%AE%9A%E3%81%97%E3%81%9F%E5%88%97%E3%81%AE%E5%BE%8C%E3%81%AB%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%82%92%E8%BF%BD%E5%8A%A0%E3%81%97%E3%81%9F%E3%81%84%E3%81%AE%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E4%BE%8B%E3%81%88%E3%81%B0%EF%BC%9A%3C%2FP%3E%3CP%3E%E6%AC%A1%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%3A%3C%2FP%3E%3CP%3E%E3%81%82%E3%81%84%E3%81%86%E3%81%88%E3%81%8A%3C%2FP%3E%3CP%3E1%202%203%204%3C%2FP%3E%3CP%3E2%204%206%208%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EB%20%E5%88%97%E3%81%AE%E5%BE%8C%E3%81%AB%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%82%92%E8%BF%BD%E5%8A%A0%E3%81%97%E3%81%9F%E3%81%84%E3%81%AE%E3%81%A7%E3%81%99%E3%81%8C%20(%E4%BB%A5%E4%B8%8B%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB)%E3%80%81B%2FA%20%E5%88%97%E3%81%AF%E5%B8%B8%E3%81%AB%20D%20%E3%81%AE%E5%BE%8C%E3%81%AB%20New%20Column%20%E9%96%A2%E6%95%B0%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%99%E3%82%8B%E3%81%A8%E3%80%81%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%20%E3%82%A4%E3%83%B3%E3%83%87%E3%83%83%E3%82%AF%E3%82%B9%E3%81%8B%E3%82%89%E9%81%A9%E5%88%87%E3%81%AA%E9%96%A2%E6%95%B0%E3%81%8C%E8%A6%8B%E3%81%A4%E3%81%8B%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%E5%88%97%E3%82%92%E6%8C%BF%E5%85%A5%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E6%8C%87%E5%AE%9A%E3%81%95%E3%82%8C%E3%81%9F%E5%88%97%E3%82%A4%E3%83%B3%E3%83%87%E3%83%83%E3%82%AF%E3%82%B9%E3%81%AB%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26lt%3B%3CNEW%20column%3D%22%22%3E%3C%2FNEW%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20B%20B%2FA%20C%20D%3C%2FP%3E%3CP%3E1%202%202%203%204%3C%2FP%3E%3CP%3E2%204%202%206%208%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-462537%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%86%E3%82%A3%E3%83%B3%E3%82%B0%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-462559%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%20%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%A7%E5%88%97%E3%82%A4%E3%83%B3%E3%83%87%E3%83%83%E3%82%AF%E3%82%B9%E3%82%92%E6%8C%87%E5%AE%9A%E3%81%97%E3%81%A6%E5%88%97%E3%82%92%E6%8C%BF%E5%85%A5%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%E3%81%A9%E3%81%86%E3%81%99%E3%82%8C%E3%81%B0%E3%82%88%E3%81%84%E3%81%A7%E3%81%99%E3%81%8B%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-462559%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%BF%E7%94%A8%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%26lt%3B%26lt%3B%20Move%20Selected%20Columns()%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%82%92%E5%BF%85%E8%A6%81%E3%81%AA%E5%A0%B4%E6%89%80%E3%81%AB%E7%A7%BB%E5%8B%95%E3%81%99%E3%82%8B%E3%83%A1%E3%83%83%E3%82%BB%E3%83%BC%E3%82%B8%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0A%2F%2F%20Open%20Data%20Table%3A%20big%20class.jmp%0A%2F%2F%20%E2%86%92%20Data%20Table(%20%22big%20class%22%20)%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2Fbig%20class.jmp%22%20)%3B%0A%0A%2F%2F%20New%20column%3A%20Column%206%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%20%22Column%206%22%2C%0A%20Numeric%2C%0A%20%22Continuous%22%2C%0A%20Format(%20%22Best%22%2C%2012%20)%0A)%20%26lt%3B%26lt%3B%20Move%20Selected%20Columns(%20%7B%3AColumn%206%7D%2C%20after(%20%3Asex%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E3%81%BE%E3%81%9F%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0A%2F%2F%20Open%20Data%20Table%3A%20big%20class.jmp%0A%2F%2F%20%E2%86%92%20Data%20Table(%20%22big%20class%22%20)%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2Fbig%20class.jmp%22%20)%3B%0A%0A%2F%2F%20New%20column%3A%20Column%206%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%20%22Column%206%22%2C%0A%20Numeric%2C%0A%20%22Continuous%22%2C%0A%20Format(%20%22Best%22%2C%2012%20)%0A)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20Move%20Selected%20Columns(%20%7B%3AColumn%206%7D%2C%20after(%20%3Asex%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Jiaxiang
Level I

How to insert a column with specified column index with JMP script?

I met a problem when writting my JMP script, I want to add the new column with a formula Y/X but there are serveal colunms and I want to add the new colunm after specified column,

For example:

A Table like:

A    B    C    D

1    2     3    4

2    4     6    8

 

and I want to add a new column after B column(like below), but the B/A column will always after D when I use New Column function, and I cannot find a good function from the scripting index , how to insert a column to a specified column index?

 

<<New Column("B/A",formula(:B/:A));

 

A    B   B/A   C    D

1    2      2     3    4

2    4      2     6    8

 

 

 

 

 

 

 

 

 

1 REPLY 1
txnelson
Super User

Re: How to insert a column with specified column index with JMP script?

Use the 

<< Move Selected Columns()

message to move the new column to where you want it

Names Default To Here( 1 );
// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "$SAMPLE_DATA/big class.jmp" );

// New column: Column 6
dt << New Column( "Column 6",
	Numeric,
	"Continuous",
	Format( "Best", 12 )
) << Move Selected Columns( {:Column 6}, after( :sex ) );

or

Names Default To Here( 1 );
// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "$SAMPLE_DATA/big class.jmp" );

// New column: Column 6
dt << New Column( "Column 6",
	Numeric,
	"Continuous",
	Format( "Best", 12 )
);

dt << Move Selected Columns( {:Column 6}, after( :sex ) );
Jim

Recommended Articles