cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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
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 IV

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

JMP18: available now.

Mauro_Gerber
Level IV

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 XII

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 XII

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

Text to 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.