Range Joining Two Data Tables (Spotfire)

[Previn Chetty 3]

Hi All,

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

 

Example:

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