How to join tables with time interval

Kevin — Tue, 19 Dec 2023 19:03:11 GMT

Hello,

I am working to join two tables, table 1 has time stamped data, and table 2 has start time and end time of each phase and cycle. I would like to join two tables so that table 1 can have phase and cycle columns.

Appreciate if anyone can show me how.

Thanks

Re: How to join tables with time interval

jthi — Tue, 19 Dec 2023 19:37:10 GMT

I would most likely try using SQL query with JMP tables. You can do this with Query()

Names Default To Here(1);

dt1 = Open("$DOWNLOADS/table1.jmp", Invisible);
dt2 = Open("$DOWNLOADS/table2.jmp", Invisible);

dt3 = Query(
	Table(dt1, "t1"),
	Table(dt2, "t2"), 
	"\[SELECT *
       FROM t1
       left join t2 on t1.'Time' >= t2.'Start Time' and t1.'Time' <= t2.'End Time'
      ]\"
);

topic Re: How to join tables with time interval in Discussions

How to join tables with time interval

Re: How to join tables with time interval