Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
I would like to join two tables together inside JMP. The first is a data table outputted from a spectrometer, the other is a reference table. The joining keys for the tables don't match exactly so I have addedmaximum and minimum key columns into the reference table to use in conditions ((if (key > min key) and (key < max key) join other reference table columns to this row).
I have previously used the JMP Query builder to join these together and it works quite well. However I am now wondering if it is possible to integrate the pick file object into this query. Essentially I would like the user to:
Run the query
Get a pop-up about which file they would like to analyse
The query would then run, matching any keys to the reference table where it falls within the minkey - maxkey region.
The user then gets the input table back, with additional columns where the query has been able to make the join.
I've been mucking around for a couple days and have had no joy. The script below asks for the pick file input, only returns the table, it doesn't attempt to make a join at all.
Have you tried doing the Pick File outside the query and just storing the path in a variable? Or, pick the file and open it before initiating the query and referencing the open data table?
I have very little experience with Query Builder, but I felt bad that no one had helped you out. Can you post some kind of sanitized version of the tables you're working with so we can try to figure it out in context?
No worries, thanks for the idea, I managed to get it to work. I stored the pick file path in a variable and then called it inside the query (just like you suggested). When I tried this previously I used the open object as well (pick file -> open -> sql query), without scucess.