| Author |
 Topic  |
|
|
Marcus Blom
Netherlands
4 Posts |
 Posted - 01/09/2020 : 06:56:32 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): Pro2018 SR1 b.9.5.1.195
Operating System: Win10
Hello,
I work with big datasets with a timestamp(Col A) & data(Col B,...).
A lot of data is per second or 10 seconds, is there a way to average the data (Col B,...) i.e per whole minute/10 minutes/hour in a different sheet?
With best regards,
Marcus |
|
|
YimingChen
1667 Posts |
Posted - 01/09/2020 : 09:11:01 AM
|
Hi Marcus,
Please try the tool from menu Analysis-> Data Manipulation -> Reduce to Evenly Spaced X. Thank you.
James |
 |
|
|
Marcus Blom
Netherlands
4 Posts |
Posted - 01/10/2020 : 03:35:34 AM
|
Hi James,
Thank you very much, this works very well.
I do have about a 100 Y-columns, and it seems I can only process one at a time...is there a trick to process these in one go?
Cheers,
Marcus |
|
|
|
YimingChen
1667 Posts |
Posted - 01/10/2020 : 09:12:49 AM
|
Yes, you can click the green lock on the top of resulting column and select Repeat this for all Y columns.
James |
Edited by - YimingChen on 01/10/2020 09:13:02 AM |
|
|
|
Marcus Blom
Netherlands
4 Posts |
Posted - 01/10/2020 : 10:56:23 AM
|
Thanks again James!
This worked out too very well.
It doesn't overwrite the averaged X-output with this option (The output is in Col A), it gives an error.
But if first select only the Y-values as output, and after that one time the X-value as an output it works all good!
Cheers,
Marcus |
|
|
|
YimingChen
1667 Posts |
Posted - 01/10/2020 : 11:50:39 AM
|
It should work if the Output is set to NewXY. Repeat the operation will generate new pairs of XY values.
James |
|
|
|
Marcus Blom
Netherlands
4 Posts |
Posted - 01/11/2020 : 11:28:02 AM
|
Hi James,
Indeed, but then I will have so many the same x-columns in between my data, which makes it not easier to process further on.
Cheers, Marcus |
|
|
| |
Topic |
|
Average Data by time