nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

hokiewoody95

Accepted answers

hogi

via Copy columns / paste columns:

All comments

hogi

via Copy columns / paste columns:

hokiewoody95

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

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:

with and without the name/header
with and without data
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.

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!