589515_en-US

liliconcom

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);

Automation and ScriptingRe: Make New Formula Column return references to the newly created columns

@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.

 

 

Re: Make New Formula Column return references to the newly created columns - Status changed to: Acknowledged

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

Re: Make New Formula Column return references to the newly created columns

JMP18: available now.

Re: Make New Formula Column return references to the newly created columns

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

Re: Make New Formula Column return references to the newly created columns

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};
*/

Re: Make New Formula Column return references to the newly created columns

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)

Re: Make New Formula Column return references to the newly created columns

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

Text to Columns 

Re: Make New Formula Column return references to the newly created columns - 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.