How to merge timestamped data

Easy Data Transform has multiple ways to merge two datasets together, including with numerical values, such as timestamps.

If you want to merge 2 sets of timestamped data, and they have identical timestamps, you can do so using a Join transform. But, if the timestamps don’t exactly match up (e.g. they have different intervals), you can easily merge them using the Interpolate transform. Here is a simple example of merging timestamped solar panel and weather station data.

Merge timestamped data

Merge ISO timestamped data

Show advanced transforms

Merge datetime timestamps

return ( new Date( $(Timestamp) ) - new Date( "2020-01-01" ) / 1000;

Seconds since 2020-01-01

transform timestamped data

convert timestamped data

ready to interpolate timestamped data

select timestamped data

interpolate timestamped data

interpolate timestamped data

interpolate timestamp data

merge timestamp data

export timestamped data

CSV timestamped data

If you need to show duplicates in lots of Excel sheets you can do it in a single operation using the batch processing feature.

As well as interpolating data, Easy Data Transform also allows you to combine 56 transforms in many other ways to quickly and easily create complex data transformations for numerical, text and date data.

Try it free now!

Windows Logo Windows Download

v1.22.0 for Windows 11 / 10 / 8 / 7 (38 MB)

Apple Logo Mac Download

v1.22.0 for Mac 12.x to 10.13 (38 MB)

Questions or problems?