cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
Tim_K
Level II

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 TimepHTemperature Data Logger TimeTemperature
2021/09/01 0:0022021/09/01 12:00200
2021/09/02 0:0032021/09/02 12:00300
2021/09/03 0:0042021/09/03 12:00400
2021/09/04 0:0052021/09/04 12:00500
2021/09/05 0:0062021/09/05 12:00600

 

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

TimepHTemperature
2021/09/01 0:002 
2021/09/02 0:003 
2021/09/03 0:004 
2021/09/04 0:005 
2021/09/05 0:006 
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

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

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.

Dan Obermiller

View solution in original post

Tim_K
Level II

Re: 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

Tim_K_0-1632326804814.png

Tim_K_1-1632326918511.png

 

 

View solution in original post

3 REPLIES 3

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.

Dan Obermiller
Tim_K
Level II

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

Tim_K
Level II

Re: 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

Tim_K_0-1632326804814.png

Tim_K_1-1632326918511.png