cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
euge
Level III

Copy/Paste without Formula Efficiently?

Could someone tell me the best way to copy/paste an entire column values into a new column efficiently (I have more than a million rows)?

The method i'm currently using is to get all values, store them to a list, and then set the values to a column, but I noticed that this is much slower than if you select the column in the table, and click paste on the column.

The reason I'm trying to do this is that I have a script that generates a new column based on some existing columns in the table, but I want to change those same columns later, without changing the new column that I created.

1 ACCEPTED SOLUTION

Accepted Solutions
euge
Level III

Re: Copy/Paste without Formula Efficiently?

nvm, found it - column("name")<<delete formula works

View solution in original post

1 REPLY 1
euge
Level III

Re: Copy/Paste without Formula Efficiently?

nvm, found it - column("name")<<delete formula works