topic Copy/Paste without Formula Efficiently? in Discussions https://community.jmp.com/t5/Discussions/Copy-Paste-without-Formula-Efficiently/m-p/7121#M7115 <HTML><HEAD></HEAD><BODY><P>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)?</P><P>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.</P><P></P><P>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.</P></BODY></HTML> Wed, 17 Jul 2013 22:31:39 GMT euge 2013-07-17T22:31:39Z Copy/Paste without Formula Efficiently? https://community.jmp.com/t5/Discussions/Copy-Paste-without-Formula-Efficiently/m-p/7121#M7115 <HTML><HEAD></HEAD><BODY><P>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)?</P><P>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.</P><P></P><P>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.</P></BODY></HTML> Wed, 17 Jul 2013 22:31:39 GMT https://community.jmp.com/t5/Discussions/Copy-Paste-without-Formula-Efficiently/m-p/7121#M7115 euge 2013-07-17T22:31:39Z Re: Copy/Paste without Formula Efficiently? https://community.jmp.com/t5/Discussions/Copy-Paste-without-Formula-Efficiently/m-p/7122#M7116 <HTML><HEAD></HEAD><BODY><P>nvm, found it - column("name")&lt;&lt;delete formula works</P></BODY></HTML> Wed, 17 Jul 2013 23:05:48 GMT https://community.jmp.com/t5/Discussions/Copy-Paste-without-Formula-Efficiently/m-p/7122#M7116 euge 2013-07-17T23:05:48Z