Jump to content

Range Joining Two Data Tables (Spotfire)

Previn Chetty 3

Recommended Posts

Hi All,

Is there a method that I can use to join two data tables on a range condition



Table1 Columns =>MachineId, MachineName, Start_Time, End_Time

Table2 Columns => EventID, LoginID, LoginName, Select_Time

Output Required =>MachineId, MachineName, Start_Time, End_Time, EventID, LoginID, LoginName, Select_Time


What I need to do:

Join Table1 to Table2 if a datetime field in Table2 (Select_Time)falls within two datetimein Table1(Start_Time & End_Time)

{ Select_Time >= Start_Time AND Select_Time

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...