The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum for Programming

LabTalk Forum

Copy columns with X in consideration

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:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Robinou	Posted - 04/11/2016 : 09:41:56 AM Hello, I have a little problem, I have two data : col(1)=Time (x) and col(2)=rotation (y) in different workbook and worksheet. All rotation was recorded with the same Time (x) frequency (2000Hz). However, all Time[1] is different and begin at different moment (betwen -1 and 1 secondes. I would like to create a summary worksheet with : ii=70; col(1)=Time=(X) and col(ii)=rotation (y). I create Time=Data(-1,5,1/2000); And i would like to place all rotation in a phase with time with no interpolation. For exemple if one rotation begin at 0,2'', -1 at 0,2'' must be empty. Thanks a lot.
2 L A T E S T R E P L I E S (Newest First)
Robinou	Posted - 04/12/2016 : 03:07:22 AM Thanks a lot! it's perfect!
Hideo Fujii	Posted - 04/11/2016 : 4:54:19 PM Hi Robinou, I still couldn't figure out exactly what kind of manipulation on worksheets you want to achieve. But, if you want to (two) worksheets simply column-wisely "join" using the Time as the key so that the each Y datasets can be shifted properly with the corresponding time, you can use *wjoinbycol* command from the Script window. http://www.originlab.com/doc/X-Function/ref/wjoinbycol For example, the following command produces the new worksheet, Book3 from Book1 and Book2: wjoinbycol irng:=([Book1]Sheet1,[Book2]Sheet1) condition:="[Book1]Sheet1!Time=[Book2]Sheet1!Time" ow:=[<new>]<new> Hope this suggestion gives you some hint. --Hideo Fujii OriginLab

The Origin Forum

Snitz Forums 2000