Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
RockerSWE
Posted - 03/31/2010 : 03:10:40 AM Hello,
While running the import wizard (from asci data file) I get the option to run a script after import. In this script I currently perform actions like adding columns, and adding two columns etc. For example, I run wcol(6)=wcol(4)*wcol(5)
Is there a way to do the script so that this formula is entered into "set column values", with auto-update enabled?
(On a side note, I am wondering whether it is possible to do a copy/paste of a "set column value" formula to another worksheet/column without using the Save/Load formula interface? Ctrl+c, ctrl+v only takes the values, not the formula)
Origin Ver. and Service Release (Select Help-->About Origin): 8.0 Operating System: Win Vista
1 L A T E S T R E P L I E S (Newest First)
larry_lan
Posted - 04/01/2010 : 02:35:45 AM No such mechanism. Maybe you can create an analysis template? You can setup the formula for the columns, once data imported, those columns will be updated. Here is an example for analysis template.