How do I join data from multiple data loggers by time axis (without using scripts)?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 |
Data Blending and CleanupWindowsRe: How do I join data from multiple data loggers by time axis (without using scripts)?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
Re: How do I join data from multiple data loggers by time axis (without using scripts)?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)?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.
