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 |