cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP Security Notice: CVE-2026-109618 and CVE-2026-109619

    JMP promptly initiated a review of its products, services, and relevant infrastructure for exposure to CVE-2026-109618 and CVE-2026-109619.

    Our assessment of JMP products has not identified exposure to these vulnerabilities. Where remediation was required within supporting environments, appropriate security updates and controls have been applied and validated.

    We have identified no evidence of successful exploitation or unauthorized access to JMP systems or customer information associated with these vulnerabilities.

    JMP continues to monitor the issue and relevant vendor guidance. No action is required by JMP customers at this time.

  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Make New Formula Column return references to the newly created columns

JMP17 has new function called New Formula Column. It would be nice if it were to return the references to the newly created columns in a list, in similar manner as << New Column does for single column. This would make using this function easier

 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
new_col = dt << New Column("Log2[height]", Numeric, Continuous, Formula(
	Log(:height, 2)
));

new_cols = dt << New Formula Column(Operation("Log 2"), Columns(:height, :weight));

Show(new_col, new_cols);
8 Comments
Sarah-Sylvestre
Level V
Status changed to: Acknowledged

Hi @jthi, thank you for your suggestion! We have captured your request and will take it under consideration.

Mauro_Gerber
Level V

@Sarah-Sylvestre Can you please also add this function to 

ref = dt << Text to Columns(columns( :Y),Delimiters( "_" ));

 

since its sometimes hard to know how many new column are created when executing the function.

 

 

hogi
Level XIII

JMP18: available now.

Mauro_Gerber
Level V

Good news, although it would be nice to extend this feature to "Text to Columns" too. @Sarah-Sylvestre 

jthi
Super User

And would be nice if JMP could decide what they want to return to make it somewhat consistent 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
new_col = dt << New Column("Log2[height]", Numeric, Continuous, Formula(
	Log(:height, 2)
));

new_cols = dt << New Formula Column(Operation("Log 2"), Columns(:height, :weight));

Show(new_col, new_cols);

/*
new_col = Column("Log2[height]");
new_cols = {:"Log2[height] 2"n, :"Log2[weight]"n};
*/
hogi
Level XIII

thank you for the hint : )

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
new_col = dt << New Column("Log2[height]", Numeric, Continuous, Formula(
	Log(:height, 2)
));

new_cols = dt << New Formula Column(Operation("Log 2"), Columns(:height, :weight));

Eval (new_col)
EvalList(new_cols)
hogi
Level XIII

Regarding  Text to columns there is also another wish to add an option to generate formulas:

Text to Columns 

Sarah-Sylvestre
Level V
Status changed to: Delivered

Hello all! Thank you for the feedback. I am marking this as delivered but your comments have been passed along to the developer.