cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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