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
 Merge date-time series data from different sources

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
AKazak Posted - 10/17/2019 : 05:07:45 AM
Origin Ver. and Service Release (Select Help-->About Origin): 2019b 9.6.5.169
Operating System: Windows 7 x64 SP1

Greetings!

I have several data files from different sensors in my experimental system.
Each file contains a column on data-time value and several columns of data.
Is there a way to merge all the data files in a single table with the unified date-time column with handling the case when more than one data file has the same date-time value?

Thank you for a detailed reply.

Data File #1
Date & Time P (Pa)
16.10.2019 09:03:00 4
16.10.2019 09:04:00 2
16.10.2019 09:04:30 13
16.10.2019 09:05:01 7

Data File #2
Date & Time T (K)
16.10.2019 09:02:00 278
16.10.2019 09:03:30 359
16.10.2019 09:04:30 290
16.10.2019 09:05:13 340

Desired Output
Date & Time P (Pa) T (K)
16.10.2019 09:02:00 278
16.10.2019 09:03:00 4
16.10.2019 09:03:30 359
16.10.2019 09:04:00 2
16.10.2019 09:04:30 13 290
16.10.2019 09:05:01 7
16.10.2019 09:05:13 340
2   L A T E S T    R E P L I E S    (Newest First)
AKazak Posted - 10/17/2019 : 11:41:24 AM
Dear Castiel,

Thank you very much --- this is exactly what I need.
Castiel Posted - 10/17/2019 : 06:45:28 AM
quote:
Originally posted by AKazak

Origin Ver. and Service Release (Select Help-->About Origin): 2019b 9.6.5.169
Operating System: Windows 7 x64 SP1

Greetings!

I have several data files from different sensors in my experimental system.
Each file contains a column on data-time value and several columns of data.
Is there a way to merge all the data files in a single table with the unified date-time column with handling the case when more than one data file has the same date-time value?

Thank you for a detailed reply.

Data File #1
Date & Time P (Pa)
16.10.2019 09:03:00 4
16.10.2019 09:04:00 2
16.10.2019 09:04:30 13
16.10.2019 09:05:01 7

Data File #2
Date & Time T (K)
16.10.2019 09:02:00 278
16.10.2019 09:03:30 359
16.10.2019 09:04:30 290
16.10.2019 09:05:13 340

Desired Output
Date & Time P (Pa) T (K)
16.10.2019 09:02:00 278
16.10.2019 09:03:00 4
16.10.2019 09:03:30 359
16.10.2019 09:04:00 2
16.10.2019 09:04:30 13 290
16.10.2019 09:05:01 7
16.10.2019 09:05:13 340



You can join worksheets by columns using X-Function wjoinbycol.
For details see https://www.originlab.com/doc/X-Function/ref/wjoinbycol


                                          &&&&&&&&&
                                        &&&
                                       &&
                                      &  _____ ___________
                                     II__|[] | |   I I   |
                                    |        |_|_  I I  _|
                                   < OO----OOO   OO---OO
**********************************************************

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