Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Joining two tables on DateTime columns


Mike Party

Recommended Posts

I have two tables with a DateTime timestamp. The times do not align perfectly (second and millisecond differences...). I would like to be able to pull data from one table into the other table under a relevant timestamp.

For an example, one data table might contain pressure data on a 1-second frequency, the other data table might contain temperature data over a 1-minute frequency. I would like to have a combined table of pressure and temperature. Unfortunately, the times have slight differences so doing the traditional join under the data canvas does not work.

Link to comment
Share on other sites

×
×
  • Create New...