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
**********************************************************
Merge date-time series data from different sources
Posted - 10/17/2019 : 05:07:45 AM
