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

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

JMP2021 — Wed, 05 Jun 2024 18:15:09 GMT

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?

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

jthi — Wed, 05 Jun 2024 18:26:52 GMT

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

next table

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

txnelson — Wed, 05 Jun 2024 20:03:15 GMT

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.