topic How do I join data from multiple data loggers by time axis (without using scripts)? in Discussions

How do I join data from multiple data loggers by time axis (without using scripts)?

Tim_K — Sat, 10 Jun 2023 23:37:19 GMT

Hello, this may be a simple question. I am trying to join data downloaded from several data loggers. The data from each datalogger comes as a table - Time Stamp vs Measurement 1, 2, 3, etc. I need to merge the data from all the data loggers into one table with a common time axis. Sometimes the timestamps match exactly, so multiple measurements can be on the same row (with the same timestamp) in the output table. What JMP dialog should I use?

Thank you in advance, Tim

Essentially, I have this:

pH Data Logger Time	pH	Temperature Data Logger Time	Temperature
2021/09/01 0:00	2	2021/09/01 12:00	200
2021/09/02 0:00	3	2021/09/02 12:00	300
2021/09/03 0:00	4	2021/09/03 12:00	400
2021/09/04 0:00	5	2021/09/04 12:00	500
2021/09/05 0:00	6	2021/09/05 12:00	600

And need to get this (time sorting can be done later):

Time	pH	Temperature
2021/09/01 0:00	2
2021/09/02 0:00	3
2021/09/03 0:00	4
2021/09/04 0:00	5
2021/09/05 0:00	6
2021/09/01 12:00		200
2021/09/02 12:00		300
2021/09/03 12:00		400
2021/09/04 12:00		500
2021/09/05 12:00		600

Re: How do I join data from multiple data loggers by time axis (without using scripts)?

Dan_Obermiller — Wed, 22 Sep 2021 00:40:49 GMT

Try Tables > Join and choose to do it by Matching Columns, where your time stamps would need to be the columns to match. You will also need to check the boxes to include nonmatches from both tables. Tables > Join will join two tables at a time.

If you have several tables, open them all in JMP and then use Tables > JMP Query Builder. This will allow you to join several tables in one step. If your time stamps all have the same column name, JMP should recognize that as the matching column. Sometimes I have run into issues where JMP Query Builder will not allow you to include the nonmatches from both tables. I have never really investigated why, but wanted you to be aware that this might happen.

Re: How do I join data from multiple data loggers by time axis (without using scripts)?

Tim_K — Wed, 22 Sep 2021 15:33:59 GMT

Dan, thank you so much for your prompt response. Let me try this. My alternative is to use Excel, but this produces larger tables that Excel cannot handle well. Best regards, Tim

Re: How do I join data from multiple data loggers by time axis (without using scripts)?

Tim_K — Wed, 22 Sep 2021 16:13:27 GMT

Hi Dan, Join Tables worked well (at least on my sample tables). The process looks similar to Combine Queries in Excel. Thank you again, Tim