The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Import Wizard Script

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

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.

Larry

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000