cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hokiewoody95
Level I

How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

1 ACCEPTED SOLUTION

Accepted Solutions
hogi
Level XIII

Re: How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

via Copy columns / paste columns:

hogi_0-1763477035284.png

 

View solution in original post

3 REPLIES 3
hogi
Level XIII

Re: How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

via Copy columns / paste columns:

hogi_0-1763477035284.png

 

hokiewoody95
Level I

Re: How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

Hi Hogi, thanks for the response. That appears to work. I was using the cut/paste options in the Edit menu, but it appears right clicking on the column gives additional, and different, cut/paste options.  Thanks!

hogi
Level XIII

Re: How do I copy columns with formulas from one data table into another data table, while preserving the formulas?

No worries, we all started somewhere.

There are multiple ways to copy columns, and there may be documentation detailing which function should be used for each approach:

  1. with and without the  name/header
  2. with and without data
  3. with and without properties, like the formula.

Is there a better way to batch copy multiple columns ? 
Copy/Paste columns from the header menu is my favorite one - it copies the column with the name, with the properties, and when you press CTRL+A before you copy the column: even with the data (caution: copy is fast, paste can be very slow!).
It's such a helpful function, but it wasn't there from the beginning:
Copy Script For Selected Column(s) to Clipboard 

... and it got better and better over the time. 
The latest improvement: JMP19 checks if the script on the clipboard is actually a column script; otherwise, it returns an error message.

hogi_0-1763491276353.png

 

More tricks like this? Just have a look at CTRL/Alt/Shift + click/select/double click/right click .
You don't need to know about all the Easter eggs listed there – simply ignore the ones you don't need.
Pick your favorite ones and enjoy the efficiency boost for JMP!

Recommended Articles