cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
JMP2021
Level III

help with adding multiple columns with formula to a new table from an old table

I generated multiple columns with formula and would like to find an efficient way to apply the same set of column to a new table without copying it one by one. Is there a shortcut?

 

2 REPLIES 2
jthi
Super User

Re: help with adding multiple columns with formula to a new table from an old table

Maybe copy/paste columns is what you are looking for? Copy Columns on the table with formulas and then Paste Columns to next table

First table

jthi_0-1717611938349.png

next table

jthi_1-1717611959642.png

 

jthi_2-1717611970159.png

 

-Jarmo
txnelson
Super User

Re: help with adding multiple columns with formula to a new table from an old table

If you are using JMP 16 or later, you can just copy the commands from the log that were placed there are the new columns were created and place them into the script editor and then run that JSL on the new data table.

Jim